database help

[RoC wonko]

Database error in vBulletin 4.2.0:

please can some one give me step by step instructions on how to fix this, nobody can login to the forum atm so very desperate for help

Invalid SQL:
DELETE FROM strikes WHERE striketime < 1344074169;

MySQL Error : Unknown column 'striketime' in 'where clause'
Error Number : 1054
Request Date : Saturday, August 4th 2012 @ 04:56:09 AM
Error Date : Saturday, August 4th 2012 @ 04:56:09 AM
Script : http://www.reign-of-chaos.co.uk/login.php?do=login
Referrer : http://www.reign-of-chaos.co.uk/admincp/index.php
IP Address : 88.97.12.60
Username : Wonko
Classname : vB_Database
MySQL Version : 5.1.63-community-log

[kh99]

For some reason you're missing a column from that table. Since there's no permanent info in that table you could just drop it and recreate it, like

drop table strikes

then

CREATE TABLE strikes (
	striketime INT UNSIGNED NOT NULL DEFAULT '0',
	strikeip CHAR(15) NOT NULL DEFAULT '',
	username VARCHAR(100) NOT NULL DEFAULT '',
	KEY striketime (striketime),
	KEY strikeip (strikeip)
)

[RoC wonko]

thank you for your reply but I am a complete novice so where do I insert the code?

--------------- Added [DATE]1344084042[/DATE] at [TIME]1344084042[/TIME] ---------------

in phpmyadmin I found this

SQL query on database reignofc_vb:

do I paste the drop table strikes into this box?
then paste the second code into the same box?

sorry just never been in this situation before & never want to come back either

[kh99]

You would need to do it somewhere where you can execute sql queries, either in the Maintenance Menu in the admincp, or using phpmyadmin (if you have that available). Edit: oops - of course you can't use the admincp if you can't log in).

Edit: OK, I see you found phpmyadmin. Yes, paste the drop table command in that box, press go, then go back to SQL query and do the second part.

[RoC wonko]

its saying i need to display at least 1 column would this be strikes?

[kh99]

I don't know why it's saying that - is that an error message when you tried to drop the table?

[RoC wonko]

I was using the wrong box now getting this message
1051 - Unknown table 'strikes'
so table is droped
now getting this
#1064 - 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 '' at line 6

[kh99]

Originally Posted by RoC wonko

#1064 - 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 '' at line 6

Hmm...just so you know, I tested it before posting and it seemed to work. Are you maybe missing the closing paren on the last line?

[RoC wonko]

it seams to have worked this time yes must have missed the paren the first attempt

--------------- Added [DATE]1344085274[/DATE] at [TIME]1344085274[/TIME] ---------------

it seams to have fixed the database error, thank you very much, just need to work out how to get into the cp panel after dbteck vbsecurity banned my ip

--------------- Added [DATE]1344085348[/DATE] at [TIME]1344085348[/TIME] ---------------

do you any way that it can be done?? the only admin who could do it before is away for a month to the states

[kh99]

Originally Posted by RoC wonko

do you any way that it can be done?? the only admin who could do it before is away for a month to the states

If you have access to ftp files, then you can try downloading your includes/config.php file and adding the following line (at the top just under <?php)

define('DISABLE_HOOKS', 1);

then upload it and overwrite the existing file. Then hopefully you can log in and disable the vbsecurity product (or do whatever you have to do to enable your ip). Remove the DISABLE_HOOKS line from your config.php when you're done.

If this doesn't work you'll have to ask dbtech - I'm not familiar with that product.