Icy Phoenix :: View topic - FAP SUPPORT - A Different SQL Error 1064

snufpunk [ Mon 11 Feb, 2008 10:19 ]
Post subject: FAP SUPPORT - A Different SQL Error 1064

Hallo,
I have just finished installing FAP 1.4.1
I was upgrading from smartors photo album 2.0.56

Everything seems to be working fine on the user side,
However, everytime i try to make a change in the admin CP for the FAP i get the following error:

Quote:
Failed to update Album configuration for viewer_language

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'h' WHERE config_name = 'viewer_language'' at line 2

UPDATE phpbb_album_config SET config_value = ''h' WHERE config_name = 'viewer_language'

Line : 380
File : admin_album_config_extended.php

I went through the installation instructions time and again, and triple checked ive done everything right.
I havent done any modifictions to the FAP files. This doesnt allow me to make any changes to the FAP through the admin CP.

HELP!

Thanks in advance for any reply at all...

Artie [ Tue 12 Feb, 2008 03:56 ]
Post subject: Re: A Different SQL Error 1064

Quote:
UPDATE phpbb_album_config SET config_value = ''h' WHERE config_name = 'viewer_language'

Strange, there is no config_name of viewer_language in the album config table...and don't think there is in Smartor's either.
Maybe you have some other mod for the album installed ???

snufpunk [ Tue 12 Feb, 2008 08:47 ]
Post subject: Re: A Different SQL Error 1064

Thanks for your reply,

I have no idea where this value came from, but as you say it seems irrelevant to FAP,
So i removed it - and now everything seems to run smoothly.

cheers.

Icy Phoenix

Archived phpBB Topics (Styles, Mods, Support) - FAP SUPPORT - A Different SQL Error 1064