Page 1 of 1

SEO Mod SQL ERROR

Posted: 22 Oct 2012, 14:44
by Cypriotmatrix
Hi all,

I went in to add all the SEO Key Words and description for each forum category and Forum, went to submit and I got the following SQL Error:

Code: Select all

SQL ERROR [ mysqli ]

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

SQL

UPDATE phpbb_forums SET parent_id = 0, forum_type = 0, forum_status = 0, forum_parents = '', forum_name = 'General Topics', forum_link = '', forum_desc = '', forum_desc_uid = '', forum_desc_options = 7, forum_desc_bitfield = '', forum_seo_key = 'Cyprus Forum, Cyprus Chat, Cyprus, Cyprus Sport, Cyprus Jokes, Cyprus Music, Cyprus Entertainment, Cyprus Music, Cyprus Tourism, Cyprus Classifieds', forum_seo_desc = 'Cyprus Forum - General Topics\nChat and debate about anything and everything!', forum_seo_bottom = '', forum_rules = '', forum_rules_uid = '', forum_rules_options = 7, forum_rules_bitfield = '', forum_rules_link = '', forum_image = '', forum_style = 0, display_subforum_list = 1, display_on_index = 0, forum_topics_per_page = 0, enable_indexing = 1, enable_icons = 0, enable_prune = 0, prune_days = 7, prune_viewed = 7, prune_freq = 1, forum_flags = 48 WHERE forum_id = 6

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/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 1238
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 189
CALL: acp_forums->update_forum_data()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_forums->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()
I don't know what all this means or how to fix it.

Can someone please help me so that I can get this mod working?

I am planning to launch my forum but only after I fix any SEO issues.

SEO Mod SQL ERROR

Posted: 22 Oct 2012, 15:05
by Stoker
Try run the installer

SEO Mod SQL ERROR

Posted: 22 Oct 2012, 15:13
by Cypriotmatrix
Stoker wrote:Try run the installer
Dis that!

I installed using AutoMod. I clicked install and it said that it installed successfully.

Is there something I am missing here? :?

SEO Mod SQL ERROR

Posted: 22 Oct 2012, 15:57
by Stoker
When installing with automod you are told to run an installer.
You need to do this to create the database entries.

SEO Mod SQL ERROR

Posted: 22 Oct 2012, 16:17
by Cypriotmatrix
Stoker wrote:When installing with automod you are told to run an installer.
You need to do this to create the database entries.
Yep I saw the instructions and ran the install.php and now the SEO Mod works.

Hopefully it will also bring good results for the forum.

Content, content, content

Boy forums are hard work! :)