DB function failed with error number 1146 - Joomla! Forum - community, help and support


hi all, have strange situation here need with.

short story - client, trying move site web host provider not playing nice web host created , maintains site.

the web host has provided old of site, file system zipped copy, included copy of sql insert script site generated using xcloner.

so step was:
download copy of joomla 1.5.26 , uploaded these files, uploaded copy of file system provided.
i create db , ran in sql insert script.

after removing installation folder , tried access site received following error need with:

jtablesession::store failed
db function failed error number 1146
table 'property_emp2.jos_session' doesn't exist sql=insert `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) values ( '8yih1klddougd4vqbhsoq1','1352599455','','0','1','0' )
fatal error: allowed memory size of 94371840 bytes exhausted (tried allocate 32 bytes) in /home/gabindesign/gabindesign.com.au/propertyemp/libraries/joomla/error/exception.php on line 117

the original site on version 1.5.21 hoping uploading copy of 1.5.26 not cause of problem.

so ideas on how can fix error.

i have create of site using akeeba backup without access ftp details cant download in binary format , web host refusing pass these details on, client has forgotten these details.

probably should try following:

(a) not install joomla!
(b) unzip files in new directory
(c) create new database
(d) create new user access database , grant privileges user
(e) import data provided in database
(f) edit file configuration.php , change values following variables reflect new directory structure , database

code: select all

   /* database settings */
   var $dbtype = 'mysql';               // mysql
   var $host = 'localhost';            // set localhost
   var $user = '';                     // mysql username
   var $password = '';                  // mysql password
   var $db = '';                     // mysql database name
   var $dbprefix = 'jos_';               // not change unless need to!

   var $tmp_path   = '/tmp';
   var $log_path   = '/var/logs';

after this, hopefully, access site.





Comments

Popular posts from this blog

How to change text Component easybook reloaded *newbee* - Joomla! Forum - community, help and support

After Effect warning: A problem occurred when processing OpenGL commands

Preconditions Failed. - Joomla! Forum - community, help and support