no tables in database after installing jojo 1.0

No tables in database after installing jojo 1.0, a forum discussion on Jojo CMS. Join us for more discussions on No tables in database after installing jojo 1.0 on our Installation forum.

Back to Forum Index : Back to Installation   RSS
rogerj

10 Aug 2012
Posts: 2

Hi

I have just installed jojo 1.0 on Windows XP and have encounted the problems listed below.

On the http://example.loc/setup/ url I get:

Created folder: My Site Plugin Directory (C:/[...]/example.org/plugins)
Created folder: My Site Theme Directory (C:/[...]/example.org/themes)
Created folder: Download Directory (C:/[...]/example.org/downloads)
Created folder: Default image upload folder for Xinha (C:/[...]/example.org/downloads/images)
Created folder: Default file upload folder for Xinha (C:/[...]/example.org/downloads/files)
Created folder: Cache Directory (C:/[...]/example.org/cache)
Created folder: Smarty Template Cache Directory (C:/[...]/example.org/cache/smarty/templates_c)
Created folder: Smarty Cache Directory (C:/[...]/example.org/cache/smarty/cache)
Created folder: Dwoo Template Cache Directory (C:/[...]/example.org/cache/dwoo/templates_c)
Created folder: Dwoo Cache Directory (C:/[...]/example.org/cache/dwoo/cache)
Created folder: Image Cache Directory (C:/[...]/example.org/cache/images)
Running setup

The Jojo setup script is an important part of the system. It applies version upgrades to the database, refreshes the cache, and performs other important housekeeping tasks. It is highly recommended that you run setup after every Jojo upgrade, and after adding any new files to plugins.

Consider running setup to be the equivalent of restarting Windows - it will fix all manner of problems, and is a good thing to do before seeking support.

If you do not see a "Setup Complete" message at the bottom of the page, it means the setup process has failed, which is usually due to a faulty install script in a plugin. The resulting error message should give some indication as to which plugin is responsible.
CREATE TABLE `sessiondata` ( `session_id` varchar(32) NOT NULL, `session_lastmodified` int(11) NOT NULL, `session_data` longblob, PRIMARY KEY (`session_id`) ) TYPE=MyISAM; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 6

#end of /setup/ page stuff
On the home page I get:
SELECT `op_name`, `op_value` FROM `option` Table 'dbdg.option' doesn't existarray(4) { [0]=> array(6) { ["file"]=> string(64) "C:[...]\jojo\plugins\jojo_core\classes\Jojo.php" ["line"]=> int(1386) ["function"]=> string(11) "selectQuery" ["class"]=> string(4) "Jojo" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> &string(42) "SELECT `op_name`, `op_value` FROM {option}" } } [1]=> array(6) { ["file"]=> string(64) "C:[...]\jojo\plugins\jojo_core\classes\Jojo.php" ["line"]=> int(1343) ["function"]=> string(10) "getOptions" ["class"]=> string(4) "Jojo" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> &bool(false) } } [2]=> array(6) { ["file"]=> string(47) "C:[...]\jojo\includes\jojo.php" ["line"]=> int(87) ["function"]=> string(9) "getOption" ["class"]=> string(4) "Jojo" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> &string(12) "sitetimezone" } } [3]=> array(4) { ["file"]=> string(58) "C:[...]\example.org\public_html\index.php" ["line"]=> int(36) ["args"]=> array(1) { [0]=> string(47) "C:[...]\jojo\includes\jojo.php" } ["function"]=> string(12) "require_once" } }

#end of home page http://example.loc/ stuff

I have already tried this:
http://www.jojocms.org/topics/299/error-with-database-installation/
and it didn't work.

Any help would be greatly appreciated.
Jaijaz Jaijaz

10 Aug 2012
Posts: 215

There was a bug in a first release of 1.0. I thought it fixed in the download. Anyway we have a 1.1 version on our Github page. I'd suggest giving that a go.
If you not living on the edge you taking up too much space.
rogerj

10 Aug 2012
Posts: 2

I have tried the 1.1 version today but discovered it had a few problems. I'd like to get 1.0 working if I can. Is there usually any problems with 1.1 installs? After installing 1.1 I encounted 404 pages for, I think it was, /contact/ etc. Am I likely to encounter less bugs with 1.1 than 1.0?
Jaijaz Jaijaz

12 Aug 2012
Posts: 215

Yeah there are definitely less bugs with 1.1 but also several changes with the way things are done. Specifically the contact plugin is many times more powerful now.

After doing the install of 1.1 you will need to create a contact page under edit pages and under the Technical tab of that page select Contact form as the plugin. This make the contact page work properly.

I think the creation of this page is now done automatically on install in the git master or at least will be moving forward but that is the process for now with the 1.1 tag.

Hope that helps. Let me know if you had any other problems with 1.1 cause we're keen to fix them quickly.
If you not living on the edge you taking up too much space.
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.