Unable to install - Joomla! Forum - community, help and support

hi,
i'm pulling hair out! trying install free version of reta (from joomlashine.com) on remote server. works locally.

the message .....you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'set foreign_key_checks = 0' @ line 1 sql=set foreign_key_checks = 0

i have checked sorts of manuals, many communiques hosting support people , tried figure out. can't . i'm hoping has had before , knows of fix, preferably easy!.

joomla version 3.5.1
php version 5.5.6
database version 5.6.14

i can install fresh bare copy of joomla 3.6, 1 install.

regards ptera.

below copy of fpa ran. guess shows errors because can't install yet.
forum post assistant
version: v1.2.7-beta (branch en-gb - language en-gb)
fpa last updated on: 04/12/2016

php supports j! 3.6.0
unknown
php api
cgi-fcgi
php supports mysql
yes
php supports mysqli
yes


mysql supports j! 3.6.0
unknown
mysql supports mysqli
unknown
mysql connection type
unknown
mysql default collation
unknown


php version
5.3.20
known buggy php
no
mysql version
unknown
known buggy zend
no

get latest tar.gz release of forum post assistant
get latest zip release of forum post assistant
Θ show forum post assistant

application instance :: discovery
cms found
joomla!
3.6.0
stable
platform
joomla platform
13.1.0
stable
config exists
no
config version
unknown
application instance :: configuration
config version
unknown
config valid
configuration not found or not valid
no application instance tests performed
database instance :: discovery
version:server: unknown client: unknown
hostname:[ -- protected -- ]
connection type:unknown
php support:php 5.3.20 support unknown
connect : not attempted, not configured
character set: unknown
default character set: unknown
database collation: unknown
database size: unknown


missing credentials detected: connection type not found mysql hostname not found table prefix not found database username not found database password not found
database instance :: performance
not connected
no database instance performance tests performed
php environment :: discovery
php version:5.3.20
php api:cgi-fcgi
display errors:
error report level:30711
mysqli support:yes
magic quotes:
safe mode:
memory limit:64m
uploads enabled:1
max. upload size:32m
max. post size:32m
max. input time:60 seconds
max. execution time:90 seconds
register globals:0

open base path:
session path:c:\windows\temp\php53
session path writable:yes
ini file path:c:\hsphere.net\3rdparty\php\php53\php.ini
last known php error:none
system environment :: discovery
platform:windows nt
kernel version:5.2
technology:i586
hostname:[ -- protected -- ]
total disk space:455.00 gib
free disk space:(32%) 145.26 gib
server:[ -- protected -- ]
server ip:[ -- protected -- ]
server signature:microsoft-iis/6.0
server encoding:gzip, deflate, sdch
executing user:iusr_438
server user:n/a

doc root:d:/hshome/fossil/planetfossil.com
server temp:c:\windows\temp
server temp writable:yes
switch user configuration:
suexec
nophp suexec
yescustom su
noownership probs
maybe


php extensions :: discovery
core
5.3.20bcmath
calendar
ctype
date
5.3.20ereg
filter
0.11.0ftp
hash
1.0iconv
json
1.2.1mcrypt
spl
0.2odbc
1.0pcre
reflection
$id: 8b8b8869e3631d1798f2b512137a0efb22e9b7b8 $session
standard
5.3.20mysqlnd
mysqlnd 5.0.8-dev - 20102224 - $id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $tokenizer
0.1zip
1.11.0zlib
1.1libxml
dom
20031129pdo
1.0.4devopenssl
simplexml
0.1wddx
xml
xmlreader
0.1xmlwriter
0.1cgi-fcgi
curl
gd
gettext
imap
mbstring
mysql
1.0mysqli
0.1phar
2.0.1pdo_mysql
1.0.2pdo_odbc
1.0.1pdo_pgsql
1.0.2soap
sockets
tidy
2.0xmlrpc
0.51xsl
0.1htscanner
1.0.0sourceguardian
8.2.1sqlsrv
2.0.1802.200pdo_sqlsrv
2.0.1802.200slog
trunk: aug 14 2012 14:03:36mhash
ioncube loader
zend guard loader
zend engine
2.3.0

potential missing extensions:

suhosin

core folders permissions checks
modewritablefoldergroupowner
777yesimages/00
777yescomponents/00
777yesmodules/00
777yesplugins/00
777yeslanguage/00
777yestemplates/00
777yescache/00
777yeslogs/00
777yestmp/00
777yesadministrator/components/00
777yesadministrator/modules/00
777yesadministrator/language/00
777yesadministrator/templates/00
elevated permissions (first 10)
modewritablefolder
777yesadministrator/ (
777yesadministrator/cache/ (
777yesadministrator/cache/kunena/ (
777yesadministrator/components/ (
777yesadministrator/components/com_admin/ (
777yesadministrator/components/com_admin/controllers/ (
777yesadministrator/components/com_admin/helpers/ (
777yesadministrator/components/com_admin/helpers/html/ (
777yesadministrator/components/com_admin/models/ (
777yesadministrator/components/com_admin/models/forms/ (
components :: site
nameversioncreatedauthoraddresstype

components :: admin
nameversioncreatedauthoraddresstype
easyslider2.1.204/26/2016joomlashine.comwww.joomlashine.com3rd party
imageshow5.0.107/14/2016joomlashine.comwww.joomlashine.com3rd party
imageshow5.0.107/14/2016joomlashine.comwww.joomlashine.com3rd party
mobilize1.2.107/22/2016joomlashine.comwww.joomlashine.com3rd party
pagebuilder1.3.107/08/2016joomlashine.comwww.joomlashine.com3rd party
poweradmin2.4.207/12/2016joomlashine.comwww.joomlashine.com3rd party
uniform4.0.007/08/2016joomlashine.comwww.joomlashine.com3rd party

modules :: site
nameversioncreatedauthoraddresstype
jsn easyslider2.1.204/26/2016joomlashine.comwww.joomlashine.com3rd party
jsn imageshow5.0.107/14/2016joomlashine.comwww.joomlashine.com3rd party
jsn uniform4.0.007/08/2016joomlashine.comwww.joomlashine.com3rd party

modules :: admin
nameversioncreatedauthoraddresstype
jsn imageshow quick icons5.0.107/14/2016joomlashine.comwww.joomlashine.com3rd party
mod_poweradmin2.4.207/12/2016joomlashine.comwww.joomlashine.com3rd party

plugins :: site
nameversioncreatedauthoraddresstype
content - jsn imageshow5.0.107/14/2016joomlashine.comwww.joomlashine.com3rd party
jsn_easyslider_plugin_content_2.1.204/26/2016joomlashine.comwww.joomlashine.com3rd party
jsn pagebuilder plugin content1.3.107/08/2016joomlashine.comwww.joomlashine.com3rd party
jsn_uniform_plugin_content_tit4.0.007/08/2016joomlashine.comwww.joomlashine.com3rd party
plg_editors_codemirror5.15.228 march 2011marijn haverbekecodemirror.net/3rd party
plg_editors_tinymce4.3.122005-2016ephox corporationwww.tinymce.com3rd party
button - imageshow5.0.107/14/2016joomlashine.comwww.joomlashine.com3rd party
jsn_easyslider_plugin_button_t2.1.204/26/2016joomlashine.comwww.joomlashine.com3rd party
button - jsn pagebuilder1.3.107/08/2016joomlashine.comwww.joomlashine.com3rd party
jsn_uniform_plugin_button_titl4.0.007/08/2016joomlashine.comwww.joomlashine.com3rd party
jsn_easyslider_plg_template2.0.803/03/2016joomlashine.comwww.joomlashine.com3rd party
source picasa1.1.803/23/2016joomlashine.comwww.joomlashine.com3rd party
theme carousel1.1.203/24/2016joomlashine.comwww.joomlashine.com3rd party
theme classic1.3.907/14/2016joomlashine.comwww.joomlashine.com3rd party
theme flow1.1.103/24/2016joomlashine.comwww.joomlashine.com3rd party
theme grid1.2.103/24/2016joomlashine.comwww.joomlashine.com3rd party
theme slider1.2.403/24/2016joomlashine.comwww.joomlashine.com3rd party
theme strip1.1.103/24/2016joomlashine.comwww.joomlashine.com3rd party
jsn pagebuilder - alert elemen@version@creationdatejoomlashine.comwww.joomlashine.com3rd party
jsn pagebuilder extended - def1.3.107/08/2016joomlashine.comwww.joomlashine.com3rd party
jsn poweradmin extended - com_2.4.207/12/2016joomlashine.comwww.joomlashine.com3rd party
jsn poweradmin extended - com_2.4.207/12/2016joomlashine.comwww.joomlashine.com3rd party
jsn poweradmin extended - com_2.4.207/12/2016joomlashine.comwww.joomlashine.com3rd party
jsn poweradmin extended - com_2.4.207/12/2016joomlashine.comwww.joomlashine.com3rd party
jsn pagebuilder extended - k2 1.3.107/08/2016joomlashine.comwww.joomlashine.com3rd party
jsn pagebuilder extended - con1.3.107/08/2016joomlashine.comwww.joomlashine.com3rd party
plg_system_jsneasyslider2.1.204/26/2016joomlashine.comwww.joomlashine.com3rd party
system - jsn imageshow5.0.107/14/2016joomlashine.comwww.joomlashine.com3rd party
plg_system_jsnframework1.6.306/20/2016joomlashine.comwww.joomlashine.com3rd party
plg_system_jsnmobilize1.2.107/22/2016joomlashine.comwww.joomlashine.com3rd party
system - jsn poweradmin2.4.207/12/2016joomlashine.comwww.joomlashine.com3rd party
plg_system_jsntplframework3.1.306/20/2016joomlashine.comwww.joomlashine.com3rd party
system - jsn pagebuilder1.3.107/08/2016joomlashine.comwww.joomlashine.com3rd party
system - jsn uniform4.0.007/08/2016joomlashine.comwww.joomlashine.com3rd party

templates :: site
nameversioncreatedauthoraddresstype
jsn_mobilize1.2.0august 29, 2012joomlashine.comwww.joomlashine.com3rd party
jsn_reta_free1.0.201/13/2016joomlashine.comwww.joomlashine.com3rd party
protostar1.04/30/2012kyle ledbetter-3rd party

templates :: admin
nameversioncreatedauthoraddresstype
isis1.03/30/2012kyle ledbetter-3rd party

legends , settings
ok/goodwarningsalerts[ -- protected -- ]

developer-mode
disabled (default )
information privacy
partial (default )
elevated permissions
show
table structure
hide (default )

diagnostic-mode
disabled (default )
components
show
modules
show
plugins
show

get latest tar.gz release of forum post assistant
get latest zip release of forum post assistant


fpa 1.2.7 copyright (c) 2011, 2012 russell winter, phil degruy, bernard toplak fpa comes absolutely no warranty. free software, , covered under gnu gplv3 or later license. welcome redistribute under conditions. details read license.txt file included in download package script. copy of license may obtained @ http://www.gnu.org/licenses/

ptera wrote:you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'set foreign_key_checks = 0' @ line 1 sql=set foreign_key_checks = 0

connect database joomla user, open query window, , execute following command:

code: select all

select @@foreign_key_checks,@@global.foreign_key_checks;

that should display current values of session , global versions of variable. if don't error, try following next:

code: select all

set foreign_key_checks = 0;

if still not getting error, try original command again see if value changed:

code: select all

select @@foreign_key_checks,@@global.foreign_key_checks;

start there , let's see happens.