NewStats: 3,265,015 , 8,185,336 topics. Date: Friday, 13 June 2025 at 07:24 AM 11k1h

6z3e3g

Urgent Help Needed With Joomla Database Transfer To Webserver - - Nairaland 4x666d

Urgent Help Needed With Joomla Database Transfer To Webserver (2875 Views)

(4)

(1) (Go Down)

Bigdreams(m): 11:41am On Aug 17, 2012
Hi friends,

Please I need your help in respect of this error stated below:

jtablesession::Store Failed
DB function failed with error number 1146
Table 'diamonf6_jml2.jml_session' doesn't exist SQL=INSERT INTO `jml_session` ( `session_id`,`time`,`name`,`gid`,`guest`,`client_id` ) VALUES ( 'ecuos6vlo71gtrrhfn4n9ibmc4','1345199937','','0','1','0' )

This error occurred after I transferred my site's database from my localhost to the webserver as I need the site to be online as soon as possible.

Please, how do I go about solving this problem.

Thanks.
Re: Urgent Help Needed With Joomla Database Transfer To Webserver by Nobody: 11:49am On Aug 17, 2012
Make a research on http://forums.digitalpoint.com/showthread.php?t=517750 stating the error code for the desired solution
guru01(m): 12:39pm On Aug 17, 2012
First thing is to the whole database again and make sure no error occur and the online db is as the phpmy.
Then transfer your website file for localhost to online folder through ftp, folder by folder don't rush the transfer.
Re: Urgent Help Needed With Joomla Database Transfer To Webserver by Nobody: 1:17pm On Aug 17, 2012
Iz that not a table prefix i am looking at there. . . . .
sarutobi: 1:57pm On Aug 17, 2012
the problem is caused by your table name prefix.

1. Delete the database and create it again

2. Go to your local joomla installation and export the tables in the database using phpmy

3. go to phpmy on the remote server and import this tables into the database.

NOTE:

1. check the configuration file "configuration.php" in the root of your joomla install and make sure the field "database_prefix" correlates with what you have in your tables. eg [tableprefix]_tablename.

2. Another cause of this problem is the fact that when you order a shared hosting, anel automatically appends ur name against all ur tables and databases. If theis is so, just edit the database prefix in the configuration.php file to match what has been appended to the table names.


Let us here a

Out.

1 Like

Bigdreams(m): 4:07pm On Aug 17, 2012
sarutobi: the problem is caused by your table name prefix.

1. Delete the database and create it again

2. Go to your local joomla installation and export the tables in the database using phpmy

3. go to phpmy on the remote server and import this tables into the database.

NOTE:

1. check the configuration file "configuration.php" in the root of your joomla install and make sure the field "database_prefix" correlates with what you have in your tables. eg [tableprefix]_tablename.

2. Another cause of this problem is the fact that when you order a shared hosting, anel automatically appends ur name against all ur tables and databases. If theis is so, just edit the database prefix in the configuration.php file to match what has been appended to the table names.


Let us here a

Out.

Thanks. Your solution put an end to the pain.

Thanks once again!
Re: Urgent Help Needed With Joomla Database Transfer To Webserver by Nobody: 4:45pm On Aug 17, 2012
u should thank me too, at least i saw the table prefix first,
i knew it was the problem, but was rushing somewhere so could not finish my post.

thanks sarutobi for clearing up the air

1 Like

yawatide(f): 11:02pm On Aug 17, 2012
I assume you've never heard of Akeeba back up? If not, I would suggest you do your transfer with that.

Good luck!
mitey(m): 8:48am On Aug 18, 2012
yawa-ti-de:
I assume you've never heard of Akeeba back up? If not, I would suggest you do your transfer with that.

Good luck!

Ditto on that. Akeeba backup is so good that I install it on every Joomla site I build. It saves a lot of time and trouble.
Bigdreams(m): 1:09pm On Aug 20, 2012
Thanks to everyone who helped out!

Appreciate you guys.
Re: Urgent Help Needed With Joomla Database Transfer To Webserver by Nobody: 1:30pm On Aug 20, 2012
u re welcome bro!
Etecscompanies(m): 2:13pm On Oct 10, 2013
Design and host your own website without touching codes, here we have Joomlia website building videos(for starters to professionals) email us to get a free sample video (ziped in a folder)
Note you can also design the famous"Bulk sms website" with this knowledge (most Bulk sms website are build with Joomlia).
Total cost of video #4500 (you can order for a free video sample
Also available Java tutor videos, photoshop and cs3 graphic videos.

email us : [email protected] )
Powered by :Etecscompanies

(1) (Reply)

Bulk Sms Business Coaching 101

(Go Up)

Sections: How To . 16
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or s on Nairaland.