importing the database issues
-
-
- Keith Ronan
- Hero Rocketeer
- Posts: 452
- Thanks: 5
-
Hi, I thought I had it all going on, but nooooooo. I have basically finished the site and have uploaded the files via ftp after changing the settings on configuration.php to go with the database. Then I imported the sql file but it errored. Here it is:
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.11.7.1
-- www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 05, 2009 at 01:13 PM
-- Server version: 5.0.41
-- PHP Version: 5.2.6
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
MySQL said:
#1193 - Unknown system variable 'SQL_MODE'
I see no tables before I imported. Shouldn;'t they have been created when I uploaded the configuration.php file. I haven't changed the log path or the tmp path. Could that be it???? HELP...
I made the mistake of promising my client. I have heard I can use joomla pack, but I want to know how this works. I have set up databases for Wordpress and calendars before...not sure what i did wrong....
Thanks in advance... - Jeremiah 29:11
For I know the plans I have for you," declares the LORD, "plans to prosper you and not to harm you, plans to give you hope and a future.
-
-
-
- Keith Ronan
- Hero Rocketeer
- Posts: 452
- Thanks: 5
-
Ok, any chance you see where my error is though?????
Should I see the tables before importing sql or no....I'm trying to narrow down where my error is.... - Jeremiah 29:11
For I know the plans I have for you," declares the LORD, "plans to prosper you and not to harm you, plans to give you hope and a future.
-
-
-
- JEM
- Preeminent Rocketeer
- Posts: 17917
- Thanks: 4
-
Well, I'm not a MySQL expert, so I can't tell you why it didn't work.
When doing this manually I usually export the DB as an SQL file (creating a .txt file) and then import the same file into the new DB (without creating tables).
Sorry I can't be of more assistance. - Thanks,
jim
-
-
-
- Keith Ronan
- Hero Rocketeer
- Posts: 452
- Thanks: 5
-
Thanks JEM..
you've been very helpful in this project. Your previous solutions allowed me to go on and make progress. I really am enjoying this joomla template solution! Have a great day....I'm off to use Joomlapack! - Jeremiah 29:11
For I know the plans I have for you," declares the LORD, "plans to prosper you and not to harm you, plans to give you hope and a future.
-
-
-
- Keith Ronan
- Hero Rocketeer
- Posts: 452
- Thanks: 5
-
Except I ran into a major problem! I used joomlapack and it was great...until the end....as I clicked Site, I got this error...:
Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /homepages/24/d226027395/htdocs/osceolawoman/components/com_jevents/libraries/jicaleventrepeat.php on line 15
It is a big issue as I have the world's most demanding client screaming for completion.
I used Mysql 4.0 first ( same error) and then Mysql 5.0 (same error) DRAG!!!!
She really wants the event calendar bad or I'd snatch it out of the site. Any suggestions??? - Jeremiah 29:11
For I know the plans I have for you," declares the LORD, "plans to prosper you and not to harm you, plans to give you hope and a future.
-
-
-
- JEM
- Preeminent Rocketeer
- Posts: 17917
- Thanks: 4
-
On your localhost, create a copy of the site, remove the calendar, upload and try again.
If the site displays OK, install the calendar again and see what happens.
Also check joomla.org and the developer's site for that error message. - Thanks,
jim
-
-
-
- Keith Ronan
- Hero Rocketeer
- Posts: 452
- Thanks: 5
- Thanks JEM..I'll let you know.....btw, I spent a few months in Japan a few years back. I'm a sax player and did some work at the Blue Notes in Osaka, Fukuoka, and one other city....can't remember where... I loved it ....loved the food big time!...
- Jeremiah 29:11
For I know the plans I have for you," declares the LORD, "plans to prosper you and not to harm you, plans to give you hope and a future.
-
-
-
- JEM
- Preeminent Rocketeer
- Posts: 17917
- Thanks: 4
-
Good luck with your client, let us know how you make out.
I know that place in Osaka, never been there though....
Pretty funny, my sister plays the sax, too.
I like being here and agree, the food is tops! - Thanks,
jim
-
-
-
- Keith Ronan
- Hero Rocketeer
- Posts: 452
- Thanks: 5
-
They have only emailed once today so far...
I am struggling figuring out what I really need to install in Jevents actually. I used the newest 1.5rc, but now even though the component is installed I can't see it in the module manager. I'm going to take a deep breath and look at it again,. It seems light on the docs on it.... - Jeremiah 29:11
For I know the plans I have for you," declares the LORD, "plans to prosper you and not to harm you, plans to give you hope and a future.
-
Time to create page: 0.098 seconds