Database errors help please
-
-
- Julian Campbell
- Elite Rocketeer
- Posts: 777
- Thanks: 0
-
I am having problems after changing my domain name and using an exisiting host. when I go to the homepage I get this error
DB function failed with error number 1146
Table 'urban.jos_session' doesn't exist SQL=SELECT session_id FROM jos_session WHERE session_id = '8668c14adeb0c7c6223daf5bb3d15b84'
SQL =
SELECT session_id
FROM jos_session
WHERE session_id = '8668c14adeb0c7c6223daf5bb3d15b84'
I have looked about for an answer but am confusing myself. I need a step by step help
Thanks
Julian
-
-
-
- Robert D. Wagers
- Elite Rocketeer
- Posts: 1545
- Thanks: 0
- Full-Time Cancer Fighter!
- I think you are using MySQL version 5.0. This is a problem that pops up. See if your web-host still has the option to run version 4.1. If they do, you try to export your tables and then attempt an import into a new 4.1 DB.
- "Everyone has to get knocked-down every once-in-a-while, otherwise you'll never learn how to get-back-up!
"
A quote attributed to my Grandpa Wagers
-
-
-
- Julian Campbell
- Elite Rocketeer
- Posts: 777
- Thanks: 0
-
Hi Keith
I didnt move hosts, I changed the domain name I had with the host from www.simply-kids.co.uk to www.urbancolour.co.uk
I have had nothing but problems since
I have been into the host control panel amd deleted the original database (simply kids) and created a new one for Urban
I am a real beginner and I think it is me that has messed this up
Julian
-
-
-
- Jandar
- Sr. Rocketeer
- Posts: 107
- Thanks: 0
- I misunderstood. So you simply switched domain names. But you mention that you deleted the previous database and created a new one. Did you install Joomla on the new domain after creating the new database? Was there any import of the old database into the new one?
-
-
-
- Robert D. Wagers
- Elite Rocketeer
- Posts: 1545
- Thanks: 0
- Full-Time Cancer Fighter!
- Like I said, I am pretty sure the new DB you created was MySQL 5.0... that is a recurring error with this version of 5.0.
- "Everyone has to get knocked-down every once-in-a-while, otherwise you'll never learn how to get-back-up!
"
A quote attributed to my Grandpa Wagers
-
-
-
- Julian Campbell
- Elite Rocketeer
- Posts: 777
- Thanks: 0
-
Thanks Rob
I have mailed my host and am waiting there reply
-
-
-
- Julian Campbell
- Elite Rocketeer
- Posts: 777
- Thanks: 0
-
Update
I have had a reply from my web host about this fault who tell me that it is an error with my Joomla install
Looks like I need to delete all files again and go from a fresh start
Hummmmm
Thanks again for your help
Julian
-
-
-
- Bob Ateah
- Elite Rocketeer
- Posts: 4521
- Thanks: 0
-
Do you have backups of your database, etc?
If not, after re-creating the site, back it up.
Best of luck.
Btw, there is automated backup software out there - joomlacloner is a great one. - The member formerly known as Roland Deschain
After your question is solved, please Edit your original post and choose the Solved message icon, thank you!
-
-
-
- Julian Campbell
- Elite Rocketeer
- Posts: 777
- Thanks: 0
-
Time to create page: 0.085 seconds