collapse

* User Info

 
 
Welcome, Guest. Please login or register.

* Recent Posts

Forum closed by whazzup
[September 25, 2021, 02:56:14 PM]


How do i replace an image file with another image file by Malu
[December 16, 2020, 03:17:02 PM]


Can't get RSG "Show My Galleries" to work by Dampfnudel
[February 25, 2019, 11:01:55 AM]


Change the order of uploaded images in the gallery by whazzup
[February 19, 2019, 10:37:29 PM]


Upload timeout for large galleries (500 images each) by whazzup
[February 11, 2019, 10:07:25 PM]


Greetings from Ronald Smit by whazzup
[January 06, 2019, 03:39:22 PM]


Pluign and module by whazzup
[June 08, 2018, 11:57:13 PM]


Version 4.4.1 released by whazzup
[May 31, 2018, 04:31:16 PM]

Author Topic: [FIXED][SVN-806] - SQL error  (Read 9235 times)

Offline Bakkegaard

  • Newbie
  • *
  • Posts: 5
[FIXED][SVN-806] - SQL error
« on: June 22, 2008, 10:30:05 PM »
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, 2008, 12:41:51 PM by john »

Offline Sean Brown

  • Newbie
  • *
  • Posts: 1
Re: [SVN-806] - SQL error
« Reply #1 on: June 23, 2008, 09:11:26 AM »
Confirmed, after upgrading mine, I can not save any configuration changes what so ever with same error.

Offline samurai

  • Newbie
  • *
  • Posts: 1
Re: [SVN-806] - SQL error
« Reply #2 on: June 25, 2008, 08:08:21 PM »
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).  :-\

Offline Hans

  • Jr. Member
  • **
  • Posts: 66
    • Kleuterdigitaal
Re: [SVN-806] - SQL error
« Reply #3 on: June 28, 2008, 05:09:58 PM »
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, 2008, 05:13:33 PM by Hans »
Hans

Open source Matters

Offline JTA

  • Newbie
  • *
  • Posts: 12
Re: [SVN-806] - SQL error
« Reply #4 on: June 28, 2008, 10:35:01 PM »
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, 2008, 11:04:52 PM by JTA »

Offline Chef Groovy

  • Retired from Dev Team
  • Full Member
  • ****
  • Posts: 110
    • Fantasy Artwork
Re: [SVN-806] - SQL error
« Reply #5 on: June 30, 2008, 05:01:25 AM »
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: [Select]
$query .= "( '$name', '" . get_magic_quotes_gpc() ? $this->$name : addslashes($this->$name) . "' ), ";
I just changed it back to svn-805

Code: [Select]
$query .= "( '$name', '" . addslashes($this->$name) . "' ), ";
Chef Groovy
RSGallery2: Legacy - Dev
Test Site: dev.fantasyartwork.net