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

uppercase letters in url - Joomla! Forum - community, help and support

-
hello all, i in process of migrating joomla 2.5 1.5. 1 of categories in 1.5 version had capital letters in name. in joomla 2.5, uppercase letters in article/menu/category alias automatically converted lowercase. i tried changing menu alias in database, caused 404 error in category-blog page. i have been trying many days find solution, reason being many of pages category in 1.5 site have lots of facebook likes don't want lose. does work-around exist allow me manually change category/menu alias category blog page , articles have category name uppercase letters? any appreciated. thanks! you can 301 redirect uppercase urls lowercase. Board index Joomla! Older Version Support Joomla! 2.5 Search Engine Optimization (Joomla! SEO) in Joomla! 2.5
Read more

Joomla! Update is not offering Joomla 3 - Joomla! Forum - community, help and support

-
hi i trying upgrade joomla 2.5.27 3.6. have checked requirements (i've upgraded site), purged cache , gone short term support, when click save & close told (as before) have latest joomla version - not offer me joomla 3.6 (or else). have suggestions please? thank you c you can download joomla 3.x update , install manually using joomla's extension installer. don't forget create backup before doing that. Board index Joomla! 3.x - Ask Support Questions Here General Questions/New to Joomla! 3.x
Read more