Manual SQL Table creation. Help please

Current Version: 1.0.6
Released: 09.01.10
Forum rules
Before creating a new support thread, please take a look in the board3 Portal FAQ and use the search!
Many questions have already been answered.
Locked

Topic author
Chef_uk
Active Member
Posts: 9
Joined: 16. March 2010 19:21
phpBB.com User: Chef_uk

Manual SQL Table creation. Help please

Post by Chef_uk »

Your Portal Version: 1.0.0RC3
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Basic Knowledge

What have you done before the problem was there?


What have you already tryed to solve the problem?
Created SQL Table within the database but have no idea what info needs placing within the table.

Description and Message
Hi, i've installed the mod (v1.0.5) without problems but visiting the new url gives me the Table 'MYDATABASE.******_portal_config' doesn't exist [1146]

Having searched around i see others have the same problem but no common fix is given so I go into phpMyAdmin and create the table manually but am stuck at the point where i fill in the table with info so could someone please post up the table's contents so i can get it to work please :) Whatever i try i get the following error:

SQL ERROR [ mysql4 ] Unknown column 'config_name' in 'field list' [1054]
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: Manual SQL Table creation. Help please

Post by Marc »

Why don't you use the installer? It creates everything in the database.

Topic author
Chef_uk
Active Member
Posts: 9
Joined: 16. March 2010 19:21
phpBB.com User: Chef_uk

Re: Manual SQL Table creation. Help please

Post by Chef_uk »

I knew that :oops: working now, thanks.

Topic author
Chef_uk
Active Member
Posts: 9
Joined: 16. March 2010 19:21
phpBB.com User: Chef_uk

Re: Manual SQL Table creation. Help please

Post by Chef_uk »

A new problem with regards to it showing up in the ACP
[phpBB Debug] PHP Notice: in file /portal/includes/functions_version_check.php on line 38: include(./mods/board3_portal_check_version.php) [function.include]: failed to open stream: Not a directory
[phpBB Debug] PHP Notice: in file /portal/includes/functions_version_check.php on line 38: include(./mods/board3_portal_check_version.php) [function.include]: failed to open stream: Not a directory
[phpBB Debug] PHP Notice: in file /portal/includes/functions_version_check.php on line 38: include() [function.include]: Failed opening './mods/board3_portal_check_version.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php')
[phpBB Debug] PHP Notice: in file /portal/includes/functions_version_check.php on line 42: call_user_func(board3_portal_check_version::version) [function.call-user-func]: First argument is expected to be a valid callback
[phpBB Debug] PHP Notice: in file /adm/index.php on line 150: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
[phpBB Debug] PHP Notice: in file /adm/index.php on line 152: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
[phpBB Debug] PHP Notice: in file /adm/index.php on line 153: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
[phpBB Debug] PHP Notice: in file /adm/index.php on line 154: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
Searching on here shows a similar problem that was solved by adding the code in to the functions.php file. I've checked mine and it is in there. Any ideas whats causing this?

Topic author
Chef_uk
Active Member
Posts: 9
Joined: 16. March 2010 19:21
phpBB.com User: Chef_uk

Re: Manual SQL Table creation. Help please

Post by Chef_uk »

Fixed it. For some reason the portal/adm/mods folder that contains the board3_portal_check_version.php file was not uploading or rather not showing up. I had to add the board3_portal_check_version.php file directly inside the admin folder and edited the command to show this:

include($phpbb_admin_path . 'board3_portal_check_version.' . $phpEx);

Works fine now.
Locked

Return to “board3 Portal 1.0.x - English Support”