Multi-site table error during installation

Multi-site table error during installation, a forum discussion on Jojo CMS. Join us for more discussions on Multi-site table error during installation on our Installation forum.

Back to Forum Index : Back to Installation   RSS
gwtardy

Multi-site, test.innaacp.org (PHP5, MySQL5, VPS--Linux (Centos)

1 Aug 2007
Posts: 4

May I please have help with an error that occured immediately after "Start Installation":

"SELECT op_name, op_value FROM `option` WHERE 1 Table 'innaacp_jojo.option' doesn't exist"?


Core files are above root in /usr/local/jojocms; website files are in http://test.innaacp.org.

Note! config/config.php needed an end tag "?>" and classes/JOJO.php needed chmod 666 to work on this system.
gwt
Harvey

Core Developer

Harvey

1 Aug 2007
Posts: 327

Hi gwt,

Almost all the PHP files in Jojo are missing the closing ?> tag, and this is the first time I have heard of this being a problem.
We chose to leave out the closing tag because it is optional, and having it there increases the chances of adding extra whitespace to the end of your files (which can cause formatting problems and will cause any HTTP headers to raise an error).
Does this problem show up only with config.php, or is it effecting other files as well?

With the SQL error on the install process, please try running http://test.innaacp.org/setup/ in your browser.

This script is a part of the installation process and does several things...
  • Checks if the required DB tables exists and creates them if they don't
  • Creates default pages in the system, such as the homepage and admin pages
  • Runs any SQL or changes required to upgrade between versions

The "options" table is a core part of Jojo, and should be created by the install process / setup script, as one of the first things that happens.
One thing that comes to mind is maybe your database user doesn't have permissions to create tables?
Database permissions required are SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX. DROP may also be required when you go to uninstall some plugins, but generally things should work fine without this permission.
gwtardy

Multi-site, test.innaacp.org (PHP5, MySQL5, VPS--Linux (Centos)

1 Aug 2007
Posts: 4

Dear Harvey,

You are correct about the php end tag (?>) being unnecessary. My Dreamweaver validity check was what got all yellow and fussy when it could not find the end tag.

Since my last message, the corrections to permissions allowed the install to proceed. DB privileges were okay. I dropped the incomplete tables repeatedly until setup indicated that all were created and populated correctly without errors.

I got a long list of messages leading to "Setup complete. Go to the Homepage or admin login to configure the install" (see attached file).

I am proceeding to "configure the install".

gwt

Attached Files

gwt
Back to Forum Index : Back to Installation   RSS
You must be logged in to post a reply



You need to Register or Log In before posting on these forums.