Mustang Evolution Forum banner

1 - 15 of 15 Posts

·
Banned
Joined
·
11,872 Posts
Discussion Starter #2

·
Banned
Joined
·
11,872 Posts
Discussion Starter #3
Database error in vBulletin 3.0.4:

Invalid SQL: Update garage_detail set views = + 1 where id = 126
mysql error: 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 where id = 126' at line 1

mysql error number: 1064

Date: Wednesday 05th of January 2005 01:19:52 AM
Script: http://www.mustangevolution.com/forum/vbgarage.php?do=view&id=126
Referer: http://www.mustangevolution.com/forum/vbgarage.php?
Username: WhiteStang99
 

·
Banned
Joined
·
11,872 Posts
Discussion Starter #5

·
15.3 Second V8 Killer Yo
Joined
·
7,212 Posts
Brent said:
Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT picture,type FROM garage_images WHERE id = 215 LIMIT 1

mysql error: Unknown column 'picture' in 'field list'

mysql error number: 1054

Date: Thursday 20th of January 2005 08:55:44 PM
Script: http://www.mustangevolution.com/forum/vbgarage.php?do=getimage&id=215
Referer: http://67.15.62.79/forums/showthread.php?t=107015&page=8&pp=25
Username: Unregistered
IP Address: 68.169.110.240
That's in code that never gets executed. Man, those damn crawlers or whatever are generating links and **** need to stop. Just like before when there were weird garage IDs being linked to. I commented that code out permanatly now.
 

·
Banned
Joined
·
11,872 Posts
Discussion Starter #8
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT garage_detail.*,user.username FROM garage_detail
LEFT JOIN user ON garage_detail.userid = user.userid where username = 'Matt'sredbeauty'
ORDER BY username asc LIMIT 0,25

mysql error: 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 'sredbeauty'
ORDER BY username asc LIMIT 0,25' at line 2

mysql error number: 1064

Date: Saturday 19th of March 2005 02:06:19 PM
Script: http://www.mustangevolution.com/forum/garage.php
Referer: http://www.mustangevolution.com/forum/garage.php
Username: Unregistered
IP Address: 66.174.77.140
 

·
Banned
Joined
·
11,872 Posts
Discussion Starter #9
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(*) AS garages FROM garage_detail
where (body like '%%' or otherbody like '%%') and (trans like '%%' or othertrans like '%%') and litres = and (adder like '%%' or adderdesc like '%%'
or adder2 like '%%' or adder2desc like '%%')
mysql error: 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 'and (adder like '%%' or adderdesc like '%%'


mysql error number: 1064

Date: Friday 25th of March 2005 04:06:44 PM
Script: http://www.mustangevolution.com/forum/garage.php
Referer: http://www.mustangevolution.com/forum/garage.php
Username: Unregistered
IP Address: 204.108.16.101
 

·
Banned
Joined
·
11,872 Posts
Discussion Starter #10
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(*) AS garages FROM garage_detail
where (body like '%%' or otherbody like '%%') and (trans like '%%' or othertrans like '%%') and litres = and (adder like '%%' or adderdesc like '%%'
or adder2 like '%%' or adder2desc like '%%')
mysql error: 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 'and (adder like '%%' or adderdesc like '%%'


mysql error number: 1064

Date: Monday 04th of April 2005 10:14:14 AM
Script: http://www.mustangevolution.com/forum/garage.php
Referer: http://www.mustangevolution.com/forum/garage.php
Username: BlackStang99
IP Address: 204.29.102.15
 

·
15.3 Second V8 Killer Yo
Joined
·
7,212 Posts
Brent said:
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(*) AS garages FROM garage_detail
where (body like '%%' or otherbody like '%%') and (trans like '%%' or othertrans like '%%') and litres = and (adder like '%%' or adderdesc like '%%'
or adder2 like '%%' or adder2desc like '%%')
mysql error: 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 'and (adder like '%%' or adderdesc like '%%'


mysql error number: 1064

Date: Monday 04th of April 2005 10:14:14 AM
Script: http://www.mustangevolution.com/forum/garage.php
Referer: http://www.mustangevolution.com/forum/garage.php
Username: BlackStang99
IP Address: 204.29.102.15

Just so you know, this is a result of the quick search on the main garage page. The search logic expects certain criteria and the quick search doesn't have them all. I found this when I looked at the apostrophe error as well. This will get uploaded with that fix.
 

·
Premium Member
Joined
·
26,052 Posts
Brent said:
Database error in vBulletin 3.0.4:

Invalid SQL:
DELETE FROM garage_ratings WHERE garid = 126

mysql error: Unknown column 'garid' in 'where clause'

mysql error number: 1054

Date: Wednesday 05th of January 2005 01:18:17 AM
Script: http://www.mustangevolution.com/forum/vbgarage.php?do=delgarage&id=126
Referer: http://www.mustangevolution.com/forum/vbgarage.php?do=view&id=126
Username: bnglcat
php may be case senitive, if so it could just need to be altered to garID, do a search of the php for garid and see what it finds, or garID and what not... find out what its supposed to be, the variable, I cant cuz im at work.
 

·
Premium Member
Joined
·
26,052 Posts
Brent said:
Database error in vBulletin 3.0.4:

Invalid SQL: Update garage_detail set views = + 1 where id = 126
mysql error: 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 where id = 126' at line 1

mysql error number: 1064

Date: Wednesday 05th of January 2005 01:19:52 AM
Script: http://www.mustangevolution.com/forum/vbgarage.php?do=view&id=126
Referer: http://www.mustangevolution.com/forum/vbgarage.php?
Username: WhiteStang99
its either supposed to be += or

Update garage_detail set views = Update garage_detail set views + 1
 

·
Banned
Joined
·
11,872 Posts
Discussion Starter #15
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT garage_detail.*,user.username FROM garage_detail
LEFT JOIN user ON garage_detail.userid = user.userid where d.id = 193
ORDER BY LIMIT ,

mysql error: 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 'LIMIT ,' at line 3

mysql error number: 1064

Date: Monday 02nd of May 2005 08:43:20 PM
Script: http://www.mustangevolution.com/forum/garage.php?do=view&id=193
Referer: http://www.mustangevolution.com/forum/garage.php?do=list&perpage=25&&page=2
Username: Unregistered
IP Address: 68.61.13.86
 
1 - 15 of 15 Posts
Top