staging MYSQL error 1146

You are here: Index > Softaculous Auto Installer > General Support > Topic : staging MYSQL error 1146

Threaded Mode | Print

staging MYSQL error 1146, table doesnt exist (7 Replies, Read 2174 times)

billyqureshi	# January 15, 2023, 11:03 pm
Group: Member Post Group: Newbie Posts: 5 Status:	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
IP: --

staging MYSQL error 1146

Brijesh	# January 17, 2023, 7:10 am \| Post: 1
Group: Softaculous Team Post Group: Super Member Posts: 5652 Status:	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
IP: --

staging MYSQL error 1146

billyqureshi	# January 17, 2023, 2:02 pm \| Post: 2
Group: Member Post Group: Newbie Posts: 5 Status:	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?
IP: --

staging MYSQL error 1146

billyqureshi	# January 17, 2023, 2:44 pm \| Post: 3
Group: Member Post Group: Newbie Posts: 5 Status:	oh sorry actually yes multisite was true ! i will comment out and try again thanks !
IP: --

staging MYSQL error 1146

Brijesh	# January 18, 2023, 6:08 am \| Post: 4
Group: Softaculous Team Post Group: Super Member Posts: 5652 Status:	Sure do let us know if you still face the issue. ----------------------- Webuzo - Multi User Hosting Control Panel AMPPS - Best WordPress/PHP/MySQL development tool
IP: --

staging MYSQL error 1146

kisozkhally	# April 19, 2024, 3:43 am \| Post: 5
Group: Member Post Group: Newbie Posts: 4 Status:	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.
IP: --

staging MYSQL error 1146

billyqureshi	# April 19, 2024, 6:49 am \| Post: 6
Group: Member Post Group: Newbie Posts: 5 Status:	Thanks Adding the multi site line did fix the issue.
IP: --

staging MYSQL error 1146

Brijesh	# April 23, 2024, 1:32 pm \| Post: 7
Group: Softaculous Team Post Group: Super Member Posts: 5652 Status:	Glad to know your issue was resolved. ----------------------- Webuzo - Multi User Hosting Control Panel AMPPS - Best WordPress/PHP/MySQL development tool
IP: --

« Previous Next »

Threaded Mode | Print

Jump To :

Users viewing this topic
	1 guests, 0 users.

All times are GMT. The time now is April 27, 2024, 12:42 am.

Powered By AEF 1.0.8 © 2007-2008 Electron Inc.

Queries: 11 | Page Created In:0.185