Forum Support

Shape 5
March 28, 2024, 11:53:09 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Shape 5 Forum
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Life Journey Site Shaper install probelm  (Read 788 times)
rtringo
Jr. Member
**
Offline Offline

Posts: 49



« on: 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

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?
Logged
mikek
Administrator
*****
Offline Offline

Posts: 28743



WWW
« Reply #1 on: January 25, 2012, 07:52:06 PM »

Hello,

What version of mysql is your server running?
Logged

Mike Knott
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
rtringo
Jr. Member
**
Offline Offline

Posts: 49



« Reply #2 on: 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
Logged
mikek
Administrator
*****
Offline Offline

Posts: 28743



WWW
« Reply #3 on: 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.
Logged

Mike Knott
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
rtringo
Jr. Member
**
Offline Offline

Posts: 49



« Reply #4 on: 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?Huh??
Logged
mikek
Administrator
*****
Offline Offline

Posts: 28743



WWW
« Reply #5 on: 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.
Logged

Mike Knott
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
wvemmerik
Jr. Member
**
Offline Offline

Posts: 1



« Reply #6 on: 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?
Logged
kasiahbug
Jr. Member
**
Offline Offline

Posts: 8



« Reply #7 on: 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
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!
Looking for the largest variety in template designs? Look no more. Never buy 1 theme again. Signups start at just $89 for access to all of our themes.
Send Us An Email
Please send us your questions and we will email you back as soon as we can. Product support questions should be posted in our support forums under the Help menu. Our staff will assist you from there.