v3.5-20231001 to v3.5-20240520
本帖最后由 xpx 于 2024-06-11 19:37 编辑v3.5-20231001 tov3.5-20240520
Did you tried the /utility/update.php ???
static/image/common/user_online.gif vot static/image/common/clock.gif 2024-06-11 21:59
Did you tried the /utility/update.php ???
Yes,
utility update.php
Copy to install
Execute *****/install/update.php
I see no problems in the code.
That table is created ok!
You have provided too little info about this situation.
Can you show a full backtrace of this bug?
Try to check the database integrity!
static/image/common/user_online.gif vot static/image/common/clock.gif 2024-06-18 09:02
I see no problems in the code.
That table is created ok!
You have provided too little info about thi ...
The database is intact.Before the upgrade, there was a "common_setting" table.After the error, the "common_setting" table disappeared.A new table "common_setting_bak" was added.
Try simply re-creating the common_setting table.
To do this, simply execute a piece of code from the install/data/install.sql file:
(Do not forget to change the table prefix!!!)
DROP TABLE IF EXISTS pre_common_setting;
CREATE TABLE pre_common_setting (
skey varchar(190) NOT NULL DEFAULT '',
svalue text NOT NULL,
PRIMARY KEY (skey)
) ENGINE=InnoDB;
And after that just insert all the corresponding data from the file /install/data/install_data.sql
like this:
INSERT INTO pre_common_setting VALUES (......);
....
INSERT INTO pre_common_setting VALUES (......);
I have a guess:
perhaps the database type before the upgrade was MyISAM,
and after the upgrade it should become INNODB.
These two engines are not compatible :(
If my guess is correct,
then before upgrading your database, you should convert it to InnoDB type! Thank you very much for your reply.
Before upgrading, the data was already InnoDB type. Was your problem solved?
Pages:
[1]