SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't exist

Current Version: 2.0.2
Released: 2013-10-27
Forum rules
Before creating a new support thread, please take a look at the board3 Portal FAQ and use the search!
Many questions have already been answered.
Locked

Topic author
Anteli
Active Member
Posts: 13
Joined: 5. October 2011 16:14
phpBB.com User: Anteli

SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't exist

Post by Anteli »

After making changes for custom side block in ACP I clicked "return to board" and I got following error message:

Code: Select all

SQL ERROR [ mysqli ]

Table 'np43689_foorumi.PORTAL_CONFIG_TABLE' doesn't exist [1146]

SQL

SELECT config_name, config_value FROM PORTAL_CONFIG_TABLE

BACKTRACE


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

FILE: portal/includes/functions.php
LINE: 26
CALL: dbal_mysqli->sql_query()

FILE: index.php
LINE: 41
CALL: obtain_portal_config()
Any ideas for this one? Thanks!
User avatar

Marc
Dev
Posts: 2504
Joined: 17. July 2008 21:08
phpBB.de User: marc1706
phpBB.com User: Marc
Location: Clausthal-Zellerfeld / München
Contact:

Re: SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't e

Post by Marc »

obtain_portal_config() doesn't get called by index.php in Board3 Portal 2.0.0b1. If you updated from Board3 Portal 1.0.6, make sure that you removed old Board3 Portal MODs from your board.

Topic author
Anteli
Active Member
Posts: 13
Joined: 5. October 2011 16:14
phpBB.com User: Anteli

Re: SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't e

Post by Anteli »

Marc wrote:obtain_portal_config() doesn't get called by index.php in Board3 Portal 2.0.0b1. If you updated from Board3 Portal 1.0.6, make sure that you removed old Board3 Portal MODs from your board.
Yes, I updated from 1.0.6.

In update.xml there was the list about files I should delete. I checked I have deleted all these files. Did you mean these files?

Code: Select all

Delete: adm/style/acp_portal.html 
Delete: language/en/mods/additional_blocks.php 
Delete: language/en/mods/info_acp_additional_blocks.php 
Delete: language/en/mods/install_portal.php 
Delete: language/en/mods/lang_portal.php 
Delete: language/en/mods/lang_portal_acp.php 
Delete: portal/block/*.* 
Delete: styles/prosilver/template/portal/portal_center.html 
Delete: styles/prosilver/template/portal/portal_left.html 
Delete: styles/prosilver/template/portal/portal_right.html 
Delete: styles/prosilver/template/portal/block/*.* 
Delete: styles/prosilver/theme/images/portal/mini_cal_icon_left_arrow.png 
Delete: styles/prosilver/theme/images/portal/mini_cal_icon_right_arrow.png 
Delete: styles/prosilver/theme/images/portal/portal_login.png 
Delete: styles/prosilver/theme/images/portal/portal_minical.png 
Delete: styles/prosilver/theme/images/portal/portal_random.png 
Delete: styles/prosilver/theme/images/portal/portal_stats.png 
Btw, on this forum, you should refresh imagesets or fix imagesets.cfg because I can see just about 3/4 of buttons. :D
User avatar

Marc
Dev
Posts: 2504
Joined: 17. July 2008 21:08
phpBB.de User: marc1706
phpBB.com User: Marc
Location: Clausthal-Zellerfeld / München
Contact:

Re: SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't e

Post by Marc »

Make sure you also edited includes/functions.php as directed by install.xml.

Did you have the Portalview MOD installed? If yes, you should also remove those edits.

Topic author
Anteli
Active Member
Posts: 13
Joined: 5. October 2011 16:14
phpBB.com User: Anteli

Re: SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't e

Post by Anteli »

Marc wrote:Make sure you also edited includes/functions.php as directed by install.xml.

Did you have the Portalview MOD installed? If yes, you should also remove those edits.
includes/functions.php is just like install.xml wants it to be. I don't have Portalview MOD installed.
User avatar

archivar
Portal Professional
Posts: 1959
Joined: 19. April 2009 21:34
phpBB.de User: archivar
phpBB.com User: archivar
Location: Deutschland

Re: SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't e

Post by archivar »

You must remove all extra modules (addons for portal) and code that access the old portal.
V.G. archivar
sorry for my bad english
Locked

Return to “Board3 Portal 2.0.x - English Support”