| Author |
 Topic  |
|
MaGraham
Senior Member
USA
1297 Posts |
 Posted - 04 July 2013 : 11:12:59
|
When trying to configure the settings for the Photo Gallery, I am receiving the following error message.
There was an error!
[MySQL][ODBC 5.1 Driver][mysqld-5.5.28]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 '1,1,1,1,1',0,50,1,480,640,100,100,0,1)' at line 1
I asked hosting about it and this was their reply:
I have checked it and was able to replicate the issue. It appears to be an issue with the sql syntax as the db is working fine. Can you let me know the exact script you are using for the website and gallery so that we can take another look at it to get more details.
Which script is the Photo Gallery using when I am in Admin Options and trying to configure the settings e.g. the number of files per user, the number of sub categories per user, etc. and I click on "submit" when finished adjusting the settings?
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 16 September 2013 19:10:00 |
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 04 July 2013 : 13:24:19
|
| Which photo gallery are you using? Point us to the Snitz Bitz mod and I will have a look.. |
Cheers,
David Greening |
 |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 04 July 2013 : 14:01:49
|
It's here, David. It's the one at the top of this page.
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=218
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 04 July 2013 15:05:27 |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 06 July 2013 : 04:49:49
|
If there's no resolution with this. . .is there another, and perhaps better, mod someone could point me to?
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 06 July 2013 : 13:34:50
|
I have one that works fine....
I customized it though like everything else...
SO glad I am through with that stuff... Keep fiddling with it all and you'll get it.
Takes time.
Good luck
http://www.wethepeopleforum.com/forum/index2.asp |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 06 July 2013 : 20:05:58
|
Thanks but I don't do coding.
Is this something for hosting to correct or is a coding issue?
I want to open my new site next week so I would really appreciate help with this.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 09 July 2013 : 12:25:46
|
| Well you're gonna have to learn SOME if you are going to mod and use Snitz, I'm afraid... |
Edited by - golfmann on 09 July 2013 12:26:46 |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 13 July 2013 : 16:02:52
|
Can no one at least answer this question that hosting asked?
Can you let me know the exact script you are using for the website and gallery so that we can take another look at it to get more details.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 13 July 2013 : 20:53:11
|
| admin_album.asp |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 14 July 2013 : 02:07:03
|
Thank you, Carefree! 
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 15 July 2013 : 13:06:08
|
Could this error be caused by the MySQL ODBC version being 5.1?
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 15 July 2013 : 18:07:52
|
Try the program again. When you get the error, leave it on the screen. Then open "admin_album.asp" and look for this line (appx 202):
strSql = "insert into " & strMemberTablePrefix & "ALBUM_CONFIG (num_files,file_size,thumbnails,base_dir,thumbnailer,img_type,approve,num_cat,pop_win,base_hight,base_width,offset_left,offset_top,single_album, Cat_Photo_Display) VALUES ("& filenum &","& filesize &","& thumbnails &",'"& basedir &"','"& thumbnailer &"','"& img_type &"',"& approve &","& numsub &","& pop_win &","& base_hight &","& base_width &","& offset_left &","& offset_top &","& single_album &","& Cat_Photo_Display &")"
After it, insert these:
Response.Write strSql
Response.End
Next, refresh the screen and report what it says here, then delete those two lines. |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 15 July 2013 : 22:30:39
|
Carefree, I couldn't just leave that screen open because it automatically closes as it also implies the changes were successful. This is the entire message.
There was an error!
[MySQL][ODBC 5.1 Driver][mysqld-5.5.28]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 '1,1,1,1,1',0,60,0,480,640,100,100,0,1)' at line 1
Album Configuration Changed!
Congratulations!
Back To Admin Home
This is the error message, below, after entering your two lines of codes in your post above.
insert into FORUM_album_CONFIG (num_files,file_size,thumbnails,base_dir,thumbnailer,img_type,approve,num_cat,pop_win,base_height,base_width,offset_left,offset_top,single_album, Cat_Photo_Display) VALUES (1600,10250,1,'/Photos','c:\thumbnailer\','1,1,1,1,1',0,60,0,480,640,100,100,0,1)
My line of code was not identical to yours though. My line is the first line (below) with yours just underneath it.
strSql = "insert into " & strTablePrefix & "album_CONFIG (num_files,file_size,thumbnails,base_dir,thumbnailer,img_type,approve,num_cat,pop_win,base_height,base_width,offset_left,offset_top,single_album, Cat_Photo_Display) VALUES ("& filenum &","& filesize &","& thumbnails &",'"& basedir &"','"& thumbnailer &"','"& img_type &"',"& approve &","& numsub &","& pop_win &","& base_height &","& base_width &","& offset_left &","& offset_top &","& single_album &","& Cat_Photo_Display &")"
strSql = "insert into " & strMemberTablePrefix & "ALBUM_CONFIG (num_files,file_size,thumbnails,base_dir,thumbnailer,img_type,approve,num_cat,pop_win,base_hight,base_width,offset_left,offset_top,single_album, Cat_Photo_Display) VALUES ("& filenum &","& filesize &","& thumbnails &",'"& basedir &"','"& thumbnailer &"','"& img_type &"',"& approve &","& numsub &","& pop_win &","& base_hight &","& base_width &","& offset_left &","& offset_top &","& single_album &","& Cat_Photo_Display &")"
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 16 July 2013 23:57:44 |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 17 July 2013 : 02:13:38
|
| Post a link to "admin_album.asp" in .txt format so I can see it. I suspect the error message is invalid and that it's actually working, because the format of the sql is perfect and matches the table settings. |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Topic |
|
|
|
