Softaculous


Topic : staging MYSQL error 1146


Posted By: billyqureshi on January 15, 2023, 11:03 pm
i have tried to create a staging site for a wp install. it errors.

i get 4 errors like this

Could not make the query numbered : 0
MySQL Error No : 1146
MySQL Error : Table 'newcast1_wp739.poppyblogs' doesn't exist

the tables named in the 4 errors are poppyblogs and poppysite

newcast1_wp739 is the new db for the staging site. poppy is the wp prefix

the source wp installation db doesnt have these tables either !

i have no idea whats going on. i can stage other sites ok. the softaculous version im on is 5.9.2 on cpanel 106.0.13

Posted By: Brijesh on January 17, 2023, 7:10 am | Post: 1
Hi,

Can you please check if the following line is present in your wp-config.php in source installation :

define( 'WP_ALLOW_MULTISITE', true );

This line is generally added when using Multisite but it seems you are not using multisite as you do not have the above mentioned tables in your source installation.

Please comment the above line in the source installation's wp-config.php

This should resolve your issue.

-----------------------
Webuzo - Multi User Hosting Control Panel
AMPPS - Best WordPress/PHP/MySQL development tool

Posted By: billyqureshi on January 17, 2023, 2:02 pm | Post: 2
hi Brijesh
thank you so much for your answer.
my source config file does not have this line.
is there anything else i can try?

Posted By: billyqureshi on January 17, 2023, 2:44 pm | Post: 3
oh sorry actually yes multisite was true !
i will comment out and try again
thanks !

Posted By: Brijesh on January 18, 2023, 6:08 am | Post: 4
Sure do let us know if you still face the issue.

-----------------------
Webuzo - Multi User Hosting Control Panel
AMPPS - Best WordPress/PHP/MySQL development tool

Posted By: kisozkhally on April 19, 2024, 3:43 am | Post: 5
Quote From : billyqureshi January 15, 2023, 11:03 pm
i have tried to create a staging site for a wp install. it errors.

i get 4 errors like this

Could not make the query numbered : 0
MySQL Error No : 1146
MySQL Error : Table 'newcast1_wp739.poppyblogs' doesn't exist

the tables named in the 4 errors are poppyblogs and poppysite

newcast1_wp739 is the new db for the staging site. poppy is the wp prefix

the source wp installation db doesnt have these tables either !  gorilla tag

i have no idea whats going on. i can stage other sites ok. the softaculous version im on is 5.9.2 on cpanel 106.0.13


I need you to verify that the following line is in your WordPress configuration file (wp-config.php) from the installation source:

output: define('WP_ALLOW_MULTISITE', true);

It appears that you are not utilizing multisite as you do not have the tables stated above in your source installation, which is why this line is typically inserted when using multisite.

Posted By: billyqureshi on April 19, 2024, 6:49 am | Post: 6
Thanks
Adding the multi site line did fix the issue.

Posted By: Brijesh on April 23, 2024, 1:32 pm | Post: 7
Glad to know your issue was resolved.

-----------------------
Webuzo - Multi User Hosting Control Panel
AMPPS - Best WordPress/PHP/MySQL development tool

Powered By AEF 1.0.8 © 2007-2008 Electron Inc.