Install issue: "error in your SQL syntax" - Joomla! Forum - community, help and support

-

every time run installation process (v3.3.6) error message reads,

you have error in sql syntax; check manual corresponds mysql server version right syntax use near '1set sql_mode = "no_auto_value_on_zero"' @ line 1 sql=1set sql_mode = "no_auto_value_on_zero"

i deleted database thinking there might have been problem database , tried again. got same result. have tried both mysql , mysqli options no change in result. checked mysql version installed on host machine , meets requirements (v5.1.59 against v5.1+ requirement).

thoughts? suggestions? thank in advance.

y'all not gonna believe this...i'm not sure believe myself. it's part stupidity, part unexplainable.

i keep going through code of install try find error. couldn't find one. posted on mysql forum well. got answer seemed interested in being insulting @ helping.

kept looking through code.

suddenly gave impulse. files had been looking @ zip file had downloaded joomla site local drive , impulse had @ files existed on server. duh! there there error, described error message.

okay, not looking @ files existed on server earlier stupidity on part. unexplainable part this: date/time stamp of file in question on server same original, unaltered file on local hard drive.

how possible? explanation can think of rod serling standing on shoulder incanting: "you have entered twilight zone."





Comments

Post a Comment

Popular posts from this blog

Warning, the Safe Path is not accessible vm3 - Joomla! Forum - community, help and support

-
i have install virtumart 3 , safe path error (vmerror: warning, safe path not accessible (does not exist or no permission), safety reasons important create folder in path not accessible url or unguessable name, create folder 'invoices' , 'keys' in store sensitive data secure. our suggested path system '/home/shop3/vmfiles/'. you can use complex folder name 'password' example '/home/shop3/public_html/administrator/components/com_virtuemart/pgq9b3kscpin/'. use link config) does have idea why, if created folder, can't warning out? virtumart virtuemart 3.0.8 joomla! 3.3.6 stable problem solved Board index Joomla! 3.x - Ask Support Questions Here Extensions for Joomla! 3.x
Read more

2.5.28 to 3.4.1---Download of update package failed - Joomla! Forum - community, help and support

-
went 2.3* whatever 2.5.28 same message.. had install via extension manager: install.. seemed work fine.. updated extensions , db.. tried run install again joomla! update module , download of update package failed message.. tried install extension manager: install. again , nothing.. don't seem have jommla_update.php file on server.. using godaddy plesk.. fun installed 3.4.1 on server using godaddy applications , worked fine.. i have seen server might out of space.. not issue here. permissions set correctly can tell. i new take easy on me.. any ideas? viewtopic.php?f=621&t=582860 Board index Joomla! 3.x - Ask Support Questions Here Migrating and Upgrading to Joomla! 3.x
Read more

Your host needs to use PHP 5.3.10 or higher to run this vers - Joomla! Forum - community, help and support

-
hi all, searched , saw nothing related it. did quickinstall of joomla 3.3.6. when goto site location in browser error in subject. server specs below. wrong in assuming should ok , if know of fix. php: 5.4.32 could double check php version? create (eg phpinfo.php) file on server containing code: select all <?php phpinfo(); and open file in browser (via eg www.example.com/phpinfo.php ) ? for safety reasons remove file server after double checking. Board index Joomla! 3.x - Ask Support Questions Here Installation Joomla! 3.x
Read more