[FIXED][SVN-806] - SQL error

« on: June 22 08:30:05 PM »

Bakkegaard Offline

Newbie

Posts: 1

[FIXED][SVN-806] - SQL error

I get this error if i try to make any changes?

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 '0jpg,jpeg,gif,png1101rsgvoting_slideshow_parth1111110111111153left91tableFileNam' at line 1 SQL=INSERT INTO jos_rsgallery2_config ( `name`, `value` ) VALUES 0jpg,jpeg,gif,png1101rsgvoting_slideshow_parth1111110111111153left91tableFileName|FileDateTime|resolutionorderingASC5gd2400/images/rsgallery/display/images/rsgallery/original/images/rsgallery/thumb/images/rsgallery/watermarked85111110debug_listeverything180005501.16.01100arial.ttf20watermark.png5(c) 2007 - RSGallery250te


« Last Edit: July 04 10:41:51 AM by john »	Logged

Reply #1

« on: June 23 07:11:26 AM »

Sean Brown Offline

Newbie

Posts: 1

Re: [SVN-806] - SQL error

Confirmed, after upgrading mine, I can not save any configuration changes what so ever with same error.


	Logged

Reply #2

« on: June 25 06:08:21 PM »

samurai

Newbie

Posts: 1

Re: [SVN-806] - SQL error

Hi everyone,

Same error when upgrading to SVN 806 on joomla 1.5.2, and when I try to save rsgallery2 config options too (once SVN 806 is installed). Undecided


	Logged

Reply #3

« on: June 28 03:09:58 PM »

Hans

Jr. Member

Posts: 65

Re: [SVN-806] - SQL error

Here the same problem with installation on Joomla 1.5.3 and downgrading is not possible. So no gallery access possible. Hope a quick fix is provided.
PHP version is 4.4.8

- An error has occurred

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 '0jpg,jpeg,gif,png1101rsgvoting_slideshow_parth1111110111111153left91tableFileNam' at line 1 SQL=INSERT INTO jos_rsgallery2_config ( `name`, `value` ) VALUES 0jpg,jpeg,gif,png1101rsgvoting_slideshow_parth1111110111111153left91tableFileName|FileDateTime|resolutionorderingASC5gd2400/images/rsgallery/display/images/rsgallery/original/images/rsgallery/thumb/images/rsgallery/watermarked85111110semantic180005501.16.01100arial.ttf20watermark.png5(c) 2007 - RSGallery250te


« Last Edit: June 28 03:13:33 PM by Hans »	Logged

Hans

Open source Matters

Reply #4

« on: June 28 08:35:01 PM »

JTA

Newbie

Posts: 12

Re: [SVN-806] - SQL error

Same here...Joomla 1.5.3 running on PHP 5.2.0 & MySQL 4.1.11...

Restore from backup is no problem, BUT most of the settings are back to default, leaving for instance commenting open to public users...

Regards
JTA


« Last Edit: June 28 09:04:52 PM by JTA »	Logged

Reply #5

« on: June 30 03:01:25 AM »

Chef Groovy Offline

Dev Team
Newbie

Posts: 18

Re: [SVN-806] - SQL error

Yeah I was trying to figure it out to fix, but apparently my php is weak. The problem is in admin/includes/config.class.php the only changed in SVN-806

I can't decipher around line 225 in admin/includes/config.class.php

Code:

$query .= "( '$name', '" . get_magic_quotes_gpc() ? $this->$name : addslashes($this->$name) . "' ), ";

I just changed it back to svn-805

Code:

$query .= "( '$name', '" . addslashes($this->$name) . "' ), ";


	Logged

Fantasy Artwork Collection
Joomla & RS Gallery
www.fantasyartwork.net