Having issues with tables.

Anti-spam MOD for phpBB3, extension for phpbb3.1
redmanuy
Posts: 11
Joined: 14 Aug 2014, 17:49
Has thanked: 2 times
Been thanked: 2 times

Having issues with tables.

Unread post by redmanuy » 14 Aug 2014, 17:51

After using the mod for awhile now Im getting different errors. When I try to the delete a post, a general error appears saying that a table is not found. When I delete the mod, it goes back to normal, still I get these errors, sorry its in spanish:

CleanTalk. Spam protection
PHP Version: 5.3.24
DBMS: MySQL 5.0.96-log
phpBB3 Version: 3.0.12

Eliminando la columna llamada ct_phone_number de la tabla phpbb_users
ERROR: La columna ct_phone_number no existe en la tabla phpbb_users.

Eliminando la columna llamada ct_request_id de la tabla phpbb_posts
ERROR: La columna ct_request_id no existe en la tabla phpbb_posts.

Eliminando la columna llamada ct_allow_links de la tabla phpbb_forums
ERROR: La columna ct_allow_links no existe en la tabla phpbb_forums.

Eliminando la columna llamada ct_moderate_registered de la tabla phpbb_forums
ERROR: La columna ct_moderate_registered no existe en la tabla phpbb_forums.

Eliminando la columna llamada ct_moderate_newly_registered de la tabla phpbb_forums
ERROR: La columna ct_moderate_newly_registered no existe en la tabla phpbb_forums.

Eliminando la columna llamada ct_moderate_guests de la tabla phpbb_forums
ERROR: La columna ct_moderate_guests no existe en la tabla phpbb_forums.

Eliminando la columna llamada enable_stoplist_check de la tabla phpbb_forums
ERROR: La columna enable_stoplist_check no existe en la tabla phpbb_forums.
Last edited by redmanuy on 14 Aug 2014, 18:03, edited 2 times in total.

redmanuy
Posts: 11
Joined: 14 Aug 2014, 17:49
Has thanked: 2 times
Been thanked: 2 times

Re: Having issues with tables.

Unread post by redmanuy » 14 Aug 2014, 18:00

When the mod works, this is the error when I try to delete a post:

General Error
SQL ERROR [ mysql4 ]

Unknown column 'ct_request_id' in 'field list' [1054]

SQL

SELECT ct_request_id FROM phpbb_posts WHERE post_id = 117072

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 193
CALL: dbal->sql_error()

FILE: [ROOT]/posting.php
LINE: 1815
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/posting.php
LINE: 315
CALL: handle_post_delete()

User avatar
shagimuratov
Administrator
Posts: 1115
Joined: 16 Mar 2011, 12:51
Has thanked: 158 times
Been thanked: 67 times
Contact:

Re: Having issues with tables.

Unread post by shagimuratov » 14 Aug 2014, 18:38

Hello,

Which one MOD version did you use? Did you unistall DB patches via UMIL wizard? You should run UMIL wizard for every install/unistall, for example,

Code: Select all

http://YOUR-WEBSITE.COM/FORUM/install/index.php
If the install/index.php doesn't exists in the root of the board, please copy this folder from MOD_ARCHIVE_ROOT/root/install.

Look forward for your reply, thanks!
These users thanked the author shagimuratov for the post:
redmanuy (16 Aug 2014, 05:01)
Rating: 50%
WBR
Denis Shagimuratov
Project leader

redmanuy
Posts: 11
Joined: 14 Aug 2014, 17:49
Has thanked: 2 times
Been thanked: 2 times

Re: Having issues with tables.

Unread post by redmanuy » 14 Aug 2014, 21:24

Thanks for the prompt response!

I downloaded the latest version and installed using automod, after that it says that I have to go to the external install file to install/uninstall. When I am uninstalling I get the error that several tables are not found. When I try to reinstall I get the 500 error due to timeout.....

User avatar
shagimuratov
Administrator
Posts: 1115
Joined: 16 Mar 2011, 12:51
Has thanked: 158 times
Been thanked: 67 times
Contact:

Re: Having issues with tables.

Unread post by shagimuratov » 15 Aug 2014, 04:55

Thanks for details and sorry for late reply.

Ok, it looks like an database issue. Do you have database backup? If you have, lets try unptach the database, please run this SQL code,

Code: Select all

ALTER TABLE `phpbb_users` DROP `ct_request_id`;
ALTER TABLE `phpbb_posts` DROP `ct_request_id`;
Does it help?
These users thanked the author shagimuratov for the post:
redmanuy (16 Aug 2014, 05:00)
Rating: 50%
WBR
Denis Shagimuratov
Project leader

redmanuy
Posts: 11
Joined: 14 Aug 2014, 17:49
Has thanked: 2 times
Been thanked: 2 times

Re: Having issues with tables.

Unread post by redmanuy » 15 Aug 2014, 14:17

Thanks, I will make a backup, run the SQL and let u know.

THANKS!
These users thanked the author redmanuy for the post:
shagimuratov (15 Aug 2014, 16:10)
Rating: 50%

redmanuy
Posts: 11
Joined: 14 Aug 2014, 17:49
Has thanked: 2 times
Been thanked: 2 times

Re: Having issues with tables.

Unread post by redmanuy » 16 Aug 2014, 23:29

Well it wont drop the tables simply because they are not there. There is an issue on the installation that after I get the Internal error code 500 (due to timeout) I keep trying to reinstall until it shows installed on the automod, but tables are not created.... since they are not created and it is a botched installation it messes the board to the point I cannot delete msgs.

Any ideas?

User avatar
shagimuratov
Administrator
Posts: 1115
Joined: 16 Mar 2011, 12:51
Has thanked: 158 times
Been thanked: 67 times
Contact:

Re: Having issues with tables.

Unread post by shagimuratov » 17 Aug 2014, 04:31

Ok. It looks like you have custom tables prefix name.

Can you please look at PHPBB_ROOT/config.php for $table_prefix? What value has this variable? My variable has,

Code: Select all

$table_prefix = 'phpbb_';
WBR
Denis Shagimuratov
Project leader

redmanuy
Posts: 11
Joined: 14 Aug 2014, 17:49
Has thanked: 2 times
Been thanked: 2 times

Re: Having issues with tables.

Unread post by redmanuy » 17 Aug 2014, 18:32

Same here....

User avatar
shagimuratov
Administrator
Posts: 1115
Joined: 16 Mar 2011, 12:51
Has thanked: 158 times
Been thanked: 67 times
Contact:

Re: Having issues with tables.

Unread post by shagimuratov » 18 Aug 2014, 04:59

Ok, can you post mysql answer for alter commands execution?
WBR
Denis Shagimuratov
Project leader

Locked