Shape 5

Joomla Templates => Life Journey - Club => : rtringo January 25, 2012, 05:27:40 PM



: Life Journey Site Shaper install probelm
: rtringo January 25, 2012, 05:27:40 PM
I am having a problem getting Life Journey Site Shaper to install

When I get to the install where sample data in inputted into the database I get

Error
Some errors occurred while populating the database: 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 '------------------------------------------------------- -- -- Table structure f' at line 3 SQL=-- -- Dumping data for table `zs2jq_users` ------------------------------------------------------- -- -- Table structure for table `zs2jq_user_profiles` -- DROP TABLE IF EXISTS `zs2jq_user_profiles`

I have tried deleting and reinstalling several times and clearing cache without any change.

http://www.profoundmysticalmeditation.com/life_journey (http://www.profoundmysticalmeditation.com/life_journey)

I have Life Journey 1.5 installed in a separate folder (newjoomala)and was in the process of just installing 1.7 and then will delete 1.5

What is going on?


: Re: Life Journey Site Shaper install probelm
: mikek January 25, 2012, 07:52:06 PM
Hello,

What version of mysql is your server running?


: Re: Life Journey Site Shaper install probelm
: rtringo January 25, 2012, 10:28:26 PM
This is what I got from the Cpanel:  5.1.60-community-log

The 1.5 version of this is running fine and installed without any major problem


: Re: Life Journey Site Shaper install probelm
: mikek January 26, 2012, 08:40:57 AM
Hello,

That is a pretty old version of mysql, is your host able to upgrade you? There were some changes in mysql around 5.2. So it's possible your server can't interpret the sql insert.


: Re: Life Journey Site Shaper install probelm
: rtringo January 27, 2012, 08:06:12 AM
Host is not able to upgrade at this time.

However I am using this same host for another 1.7 template Paradigm Shift and it installed and ran fine.

I deleted the zip file and all other upzipped files, reloaded, and got the very same error at  Step 6 Configuration when loading the sample data

Error
Some errors occurred while populating the database: 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 '------------------------------------------------------- -- -- Table structure f' at line 3 SQL=-- -- Dumping data for table `cgu01_users` ------------------------------------------------------- -- -- Table structure for table `cgu01_user_profiles` -- DROP TABLE IF EXISTS `cgu01_user_profiles`

Any other ideas??????


: Re: Life Journey Site Shaper install probelm
: mikek January 27, 2012, 08:29:02 AM
Hello,

I've tested it locally and it's still fine, so there is either an issue with the server or a version issue. Are you familiar with using phpmyadmin? What you could do is, finish the install how it is, and then go to your paradigm shift database table and copy over the user_profiles table from there (change the table prefix obviously). The user_profiles table is standard across all joomla installs, so it will contain the same data.


: Re: Life Journey Site Shaper install probelm
: wvemmerik January 29, 2012, 10:48:54 AM
Fout
Er zijn enkele fouten ontstaan bij het invoeren in de database: 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 '------------------------------------------------------- -- -- Table structure f' at line 3 SQL=-- -- Dumping data for table `jos_users` ------------------------------------------------------- -- -- Table structure for table `jos_user_profiles` -- DROP TABLE IF EXISTS `jos_user_profiles`

Ik krijg de zelfde fout als ik de : Life Journey Site Shaper installeerd. Ook kan ik dan niet aanloggen op het admin console. de ingegeven usernaam en het bijbehorende password werkt dan niet.

Ik heb dit draaien op een WAMPSERVER2 met SQL versie 5.1.41

Wat is hie aan te doen?


: Re: Life Journey Site Shaper install probelm
: kasiahbug February 11, 2012, 03:52:48 PM
I got the same exact error in the same step (I use GoDaddy hosting) but installed and was going to move on to the suggestion, but the site and backend both appear to not have any problems as of yet. I have not checked the log in though