What is wrong with this code?

[Odil]

DELETE FROM 'settingGROUP' WHERE 'settinggroupid' ='35' LIMIT1

I get errors and this is the code phpmyadmin produced itself. What should it be to delete a setting group in vb 2.2.6?

Odil

[joecool]

i think it supposed to look like::

query("DELETE FROM settingGROUP WHERE settinggroupid =35 LIMIT1");

But i am very new to mysql so if this is totally wrong please 4give me.

[Issvar]

What errors do you get?

And why do so many people besides you as well don't post the error message, but expect the forum members to be psychic and just know what the error is?

[NTLDR]

[sql]DELETE FROM 'settinggroup' WHERE 'settinggroupid' ='35';[/sql]
Note the case of the words.

[Odil]

Originally posted by NTLDR
[sql]DELETE FROM 'settinggroup' WHERE 'settinggroupid' ='35';[/sql]
Note the case of the words.

Again I get the same error below:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: DELETE FROM 'settinggroup' WHERE 'settinggroupid' ='35';

mysql error: You have an error in your SQL syntax near ''settinggroup' WHERE 'settinggroupid' ='35';
' at line 1

mysql error number: 1064

I am starting to think there is an error in the settinggroup itself, As a test, I deleted something else that I didn't need using the same code that phpmyadmin geberates and it deleted just fine.

Odil

[g-force2k2]

run this query...

PHP Code:

DELETE FROM settinggroup WHERE settinggroupid=35 


regards...

g-force2k2

[Odil]

Originally posted by g-force2k2
run this query...

PHP Code:

DELETE FROM settinggroup WHERE settinggroupid=35 


regards...

g-force2k2

It gets this error:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: DELETE FROM settinggroup WHERE settinggroupid=35
mysql error: Can't open file: 'settinggroup.MYD'. (errno: 144)

mysql error number: 1016

[NTLDR]

Do your forums work correctly / can you change settings in the Admin CP, if not run repair.php from the extra folder in the zip, your DB may be corrupt.