no tables in database after installing jojo 1.0

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.

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.

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.

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 [url=https://github.com/organizations/JojoCMS]Github page[/url]. I'd suggest giving that a go.

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?

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?

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.

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.