Forum SEO Error

Post by **unlocksolutions** » 14 Sep 2011, 09:22

Hello. I tried installing Forum SEO on my board but it has since given me sql errors during installation and after. Here is an excerpt of the error log

Forum seo
PHP Version: 5.2.17
DBMS: MySQL 5.0.92-community
phpBB3 Version: 3.0.7-PL1

'Removing the column named forum_seo_bottom from table phpbb_sforums
ERROR: The column forum_seo_bottom does not exist on table phpbb_sforums. SQL ERROR Table 'thehardd_ngige.phpbb_ssforums' doesn't exist

Removing the column named forum_seo_desc from table phpbb_sforums
ERROR: The column forum_seo_desc does not exist on table phpbb_sforums. SQL ERROR Table 'thehardd_ngige.phpbb_ssforums' doesn't exist

Removing the column named forum_seo_key from table phpbb_sforums
ERROR: The column forum_seo_key does not exist on table phpbb_sforums. SQL ERROR Table 'thehardd_ngige.phpbb_ssforums' doesn't exist'

Post by **Stoker** » 14 Sep 2011, 09:28

This error tells that you are trying to remove some database entries that doesnt exist in the first place.

Forum SEO includes an umil installer.
What happened when you ran the included installer?

Post by **unlocksolutions** » 14 Sep 2011, 09:32

It gave me an error....that it could not find some entries
Now whenever i try create a forum i get this error

'General Error
SQL ERROR [ mysql4 ]

[0]

SQL

No values specified for SQL IN comparison

BACKTRACE

FILE: includes/db/dbal.php
LINE: 379
CALL: dbal->sql_error()

FILE: includes/hooks/hook_subject_prefix.php
LINE: 126
CALL: dbal->sql_in_set()

FILE:
LINE:
CALL: sp_hook::add_subject_prefix_to_page()

FILE: includes/hooks/index.php
LINE: 141
CALL: call_user_func_array()

FILE: includes/template.php
LINE: 208
CALL: phpbb_hook->call_hook()

FILE: includes/functions.php
LINE: 4535
CALL: template->display()

FILE: index.php
LINE: 329
CALL: page_footer()'

Post by **Stoker** » 14 Sep 2011, 09:37

Simply undo the edits from the SEO mod.

Post by **unlocksolutions** » 14 Sep 2011, 09:42

Am quite new at this....can you explain how to do so

Post by **unlocksolutions** » 14 Sep 2011, 09:59

I have also tried to install paypal donate 5 mins ago and i think it kiiled the board.......
This is the error am also getting
General Error
SQL ERROR [ mysql4 ]

[0]

SQL

No values specified for SQL IN comparison

BACKTRACE

FILE: includes/db/dbal.php
LINE: 379
CALL: dbal->sql_error()

FILE: includes/hooks/hook_subject_prefix.php
LINE: 126
CALL: dbal->sql_in_set()

FILE:
LINE:
CALL: sp_hook::add_subject_prefix_to_page()

FILE: includes/hooks/index.php
LINE: 141
CALL: call_user_func_array()

FILE: includes/template.php
LINE: 208
CALL: phpbb_hook->call_hook()

FILE: includes/functions.php
LINE: 4535
CALL: template->display()

FILE: index.php
LINE: 329
CALL: page_footer()

Post by **Stoker** » 14 Sep 2011, 10:01

The opposite way that you installed it.
If you used automod to install it you can use automod to uninstall it.
If you edited the files yourself then remove/undo the edits.

Post by **unlocksolutions** » 14 Sep 2011, 10:04

Actualy when i installed i used automod....it gave me an error and i also uninstalled using automod and still got an error.....in short when i install and uninstall using automod i get the errors......is there any solution for this

Post by **Stoker** » 14 Sep 2011, 10:07

"an error" could be a lot of different things.
I have no idea what happened.

But it looks like you havent installed the database entries, so you dont have to uninstall those.
Then you just have to reupload the files that didnt get edited. I hope you have backup of those files?