SEO Mod SQL ERROR

Modifications for phpBB3.
Try the Mods here and share Your own Mods
Forum rules
You dont have to use ModX or make your mod AutoMod compatible. A simple textfile is fine
But if you post Mods here You also have to give support

SEO Mod SQL ERROR

Post 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

Post by Stoker »

Try run the installer

SEO Mod SQL ERROR

Post 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

Post 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

Post 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! :)