GTS-T Rob
Member
Registered: 20th Jul 05
Location: Cambridgeshire Drives: Skyline
User status: Offline
|
basically i enabled visual confirmation for registering, due to gash spam bots signing up
i enabled it, now when people try to register they get this message
Could not delete stale confirm data
DEBUG MODE
SQL Error : 1146 Table 'cruisin_phpbb.phpbb_confirm' doesn't exist
DELETE FROM phpbb_confirm WHERE session_id NOT IN ('0de265246b5de572194ff5d6bfb5863b', '17aed13f5dd76096af10ee174fa6aa2f', '184b9059460e3d17d3eb19b69f0f32d9', '18fda2c3f2163be4b1e95d634b1a3dda', '1e412c235dbf257ae0c10189944eabc6', '2318226a60fbd96f51fdc6d8e37d8330', '25927f0950d854c35a63aca21ae36cf5', '2c3c29e4cb5300d212b0723ea1fb0c28', '2e06e6174985a66fd85d61d452d3d3dd', '327b4026c7ab23a77051d446cdaf0b7a', '34f544e2b903b378b2363b4ade61018c', '3669a41adf25cceec930542abd5151c7', '3ba7697cbb5b7c4447642b419a3d412a', '3c3daef7772b12bca1955548fd89ad37', '4032fc1217916fc77655207fda10f1bc', '42bbee40dac4bab36dbe7eb2a544abba', '472cd0340722e01a79ee4b4a8b2059e0', '474974a398c8cf9381a5ac8ab66c39cb', '4b72ad4b907a76017149dd12a4da0197', '4c68ef29b336dd32f1a91f90fd266870', '53303ffa29b866c28c9850af089d2e7d', '59b9d6dc263c1383c99fc0a975be7888', '5de11f2e784c97c4cd3b5488adc640e5', '69004ba1594e6bef0f696febc38471da', '6d09c15a57dc9e0502796297f7b94f2a', '7ced9f6d72ad3eed154c85562550efea', '7d5d6eabc241f9056213a3183b0b5036', '7f1db72f3c1735da38d0bc7871cb111a', '876326e937f07696c8910a3adbe64ff7', '8ee0dfa6ae6a43a803e642d273546675', 'a2c2ad04db232bd6a22ee4356e05c435', 'a3eb7b5f48b9181975a847b9263b4b68', 'acc43ab63eca7ba15bc5e177a5b93e4e', 'b93646356696cd675ba9b7ae2a935fe2', 'bb21452e0a5f2e65adcba54188ee9794', 'bdea22db23d26ddea26e68d50546eb0d', 'c7d19b60e7215fe8d1f13e0b43dc3467', 'cd04cf52024751b2ee475fd1f5ee1cdb', 'cf39778a0775dee0ff484a550310d0b4', 'd3739f406fa3604ad181b58f99bd37d4', 'ddae6ad582bb19ccb38508699ed0c739', 'e6870603550e3f8d5eb4e7d7fc16a7e6', 'e78022a343efc1be3f949ba5ee759d77', 'f5fa4582b427e6cb082c762f9a6a4156', 'f640b71c8710e026017280444ba4f9ca', 'f8c57f34a8859a2cb19f4266b9d1fdd4', 'fa51172764b4332c3d02a7118b74cf48')
Line : 965
File : usercp_register.php
any idea on how to sort it and whats it all about? 
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
Well to cut a long story short it cant find the phpbb_confirm table in your database.
Made any DB changes recently?
|
GTS-T Rob
Member
Registered: 20th Jul 05
Location: Cambridgeshire Drives: Skyline
User status: Offline
|
no i havnt mate, what would i have to do to sort this
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
Do you know much about MySQL?
|
GTS-T Rob
Member
Registered: 20th Jul 05
Location: Cambridgeshire Drives: Skyline
User status: Offline
|
very little? not an easy job?
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
It is easy.
You need to run the following script against your database:
DROP TABLE IF EXISTS phpbb_confirm;
CREATE TABLE phpbb_confirm(
confirm_id char(32) NOT NULL,
session_id char(32) NOT NULL,
code char(6) NOT NULL,
PRIMARY KEY (session_id, confirm_id)
);
|
GTS-T Rob
Member
Registered: 20th Jul 05
Location: Cambridgeshire Drives: Skyline
User status: Offline
|
thats all that needs doing? how long would it take? :S
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
quote:
Originally posted by Cruising Corsa
thats all that needs doing? how long would it take? :S
Takes about 30 seconds if you know how to do it.
If you don't know how to do it, it's not the sort of thing that's easy to explain over the internet.
Do you have any MySQL front end software?
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
you need to drop the cruisin_phpbb bit but you need to check in your database which table is actually there first
|
GTS-T Rob
Member
Registered: 20th Jul 05
Location: Cambridgeshire Drives: Skyline
User status: Offline
|
cheers guys, i dont know a lot so i just had a look about and i have two databases...
cruisin_phpbb and cruisin_phpbb1
the confirm table was in the phpbb1 yet the forum was going through the phpbb
the _confirm table was in the phpbb1 database but not in the phpbb one that the forum was trying to find, i just copied the table from one database to the other and its sorted it
ive not read through this post so sorry if its jibberish, ive got to go xxx
thanks for help guys 
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
id try and sort it so its all in one table, not quite sure how youev managed that tbh
|
GTS-T Rob
Member
Registered: 20th Jul 05
Location: Cambridgeshire Drives: Skyline
User status: Offline
|
its working now, the table was on the other database, there was an option to 'copy' the phpbb_confirm onto the other database
worked a treat
|
