MyBB Community Forums

Full Version: Populating tables stage appears to fail
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi

I am doing a clean install of MyBB 1.6 on Centos 5 (in VirtualBox).  I have created the MySql database and have got to the following point in the MyBB install process:

Connection to the database server and database you specified was successful.

Database Engine: MySQLi 5.1.73

The MyBB database tables will now be created.

Creating table mybb_adminlog...done

Creating table mybb_adminoptions...done

Creating table mybb_adminsessions...done

Creating table mybb_adminviews...done

Creating table mybb_announcements...done

Creating table mybb_attachments...done

Creating table mybb_attachtypes...done

Creating table mybb_awaitingactivation...done

Creating table mybb_badwords...done

Creating table mybb_banfilters...done

Creating table mybb_banned...done

Creating table mybb_calendars...done

Creating table mybb_calendarpermissions...done

Creating table mybb_captcha...done

Creating table mybb_datacache...done

Creating table mybb_delayedmoderation...done

Creating table mybb_events...done

Creating table mybb_forumpermissions...done

Creating table mybb_forums...done

Creating table mybb_forumsread...done

Creating table mybb_forumsubscriptions...done

Creating table mybb_groupleaders...done

Creating table mybb_helpdocs...done

Creating table mybb_helpsections...done

Creating table mybb_icons...done

Creating table mybb_joinrequests...done

Creating table mybb_massemails...done

Creating table mybb_mailerrors...done

Creating table mybb_maillogs...done

Creating table mybb_mailqueue...done

Creating table mybb_moderatorlog...done

Creating table mybb_moderators...done

Creating table mybb_modtools...done

Creating table mybb_mycode...done

Creating table mybb_polls...done

Creating table mybb_pollvotes...done

Creating table mybb_posts...done

Creating table mybb_privatemessages...done

Creating table mybb_profilefields...done

Creating table mybb_promotions...done

Creating table mybb_promotionlogs...done

Creating table mybb_reportedposts...done

Creating table mybb_reputation...done

Creating table mybb_searchlog...done

Creating table mybb_sessions...done

Creating table mybb_settinggroups...done

Creating table mybb_settings...done

Creating table mybb_smilies...done

Creating table mybb_spiders...done

Creating table mybb_stats...done

Creating table mybb_tasks...done

Creating table mybb_tasklog...done

Creating table mybb_templategroups...done

Creating table mybb_templates...done

Creating table mybb_templatesets...done

Creating table mybb_themes...done

Creating table mybb_themestylesheets...done

Creating table mybb_threadprefixes...done

Creating table mybb_threadratings...done

Creating table mybb_threadviews...done

Creating table mybb_threads...done

Creating table mybb_threadsread...done

Creating table mybb_threadsubscriptions...done

Creating table mybb_userfields...done

Creating table mybb_usergroups...done

Creating table mybb_users...done

Creating table mybb_usertitles...done

Creating table mybb_warninglevels...done

Creating table mybb_warningtypes...done

Creating table mybb_warnings...done

All tables have been created, click Next to populate them.

When I click Next the browser window goes blank and nothing appears.

Please can anyone suggest what I have done wrong?

Best regards

David
Can you enable error logging in Apache and check the error logs? What version of PHP? It's probably hitting a fatal error somewhere.
(2015-03-12, 03:04 AM)spork985 Wrote: [ -> ]Can you enable error logging in Apache and check the error logs? What version of PHP? It's probably hitting a fatal error somewhere.

Thanks for your reply.  The Apache error log shows:

[Sat Mar 14 17:50:55 2015] [error] [client <snip>] PHP Parse error:  syntax error, unexpected T_STRING in /var/www/html/forums/inc/config.php on line 15

$ php -v
PHP 5.3.3 (cli) (built: Oct 30 2014 20:12:53)
Copyright © 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright © 1998-2010 Zend Technologies

Is that ok?

Best regards

David

I think that the error I am seeing may be caused by the fact that I entered the MySQL Database Username with quotes on the MyBB setup screen.

That is, I entered:

'myusername'

including those single quotes.

Assuming that is the problem, how can I delete the details I entered and start again with the MyBB setup? (I seem to be stuck half-way through it.)

Best regards

David
I wonder if some of the experts could take a fresh look at this problem please?

In summary, I (probably) wrongly entered the MySQL Database Username with quotes around it.  The install script now does not run and I get an error in the Apache log (see above if needed).

How can I clear any cached details and restart the script?
can we have your forum url ? does it show blank page ?

basically you should be able to rectify mistake in ~/inc/config.php file (line 15) [& run the installer again if required]
$config['database']['username'] = '_______';
Thanks for your reply.  My installation is a test system on a virtual machine, so there's no external access.

I fixed the error in ~/inc/config.php, as you suggested, and the install script came back to life and said MyBB is already installed.

Now when I access:

http://192.168.2.5/forums/

I see:

MyBB Internal error

MyBB has experienced an internal error and cannot continue.

Error Type:

    MyBB Error (43)

Error Message:

    The install directory (install/) still exists on your server and is not locked. To access MyBB please either remove this directory or create an empty file in it called 'lock'.

Any idea what to do next please?
^ you can delete install folder or add an empty file named lock
Thanks, now I get:

Error Type:

    MyBB Error (42)

Error Message:

    Your board has not yet been upgraded. Please do so before attempting to browse it.

Do I need to upgrade now? If so, how please?
if I understand it correctly, you have installed a fresh forum of MyBB 1.6.16 by choosing a newly created database.
if that is right then looks like installation did not run fine. anyway, you can run upgrade script & it might get fixed.

if you have added empty file lock in install folder then delete that file and visit
http://192.168.2.5/forums/install/upgrade.php

if you had deleted install folder then you have to add it back and run the upgrade script
When I run the upgrade script I have to enter the MyBB administrator credentials but I never specified those.

This isn't going so well. Perhaps I should do a clean install. How would I best do that please?

(2015-03-17, 07:36 PM)DavidA Wrote: [ -> ]When I run the upgrade script I have to enter the MyBB administrator credentials but I never specified those.

This isn't going so well. Perhaps I should do a clean install.  How would I best do that please?

It's ok - I did a fresh install and all is ok.

Thanks for your help.