Update from 2.5 to 3.0 bug

mj1919

URGENT, PLEASE!
when i update, get this error!
i execute that command in database (phpmyadmin), but when i re-ran update, shown same error!! what can i do?

mj1919

UPPPPP
NO ONE HERE?

vot

Copy/paste here the SQL query.
I'll test it.

mj1919

vot 2013-8-27 09:47
Copy/paste here the SQL query.
I'll test it.

Here you are:

1. ALTER TABLE pre_common_diy_data CHANGE `targettplname` `targettplname` varchar(128) NOT NULL DEFAULT '', CHANGE `tpldirectory` `tpldirectory` varchar(128) NOT NULL DEFAULT '', ADD PRIMARY KEY (targettplname,tpldirectory)

Copy the Code

vot

Try this:

Edit install/data/install.sql

Find:
  PRIMARY KEY (targettplname,tpldirectory)

Replace with:
  KEY targettplname (targettplname),
  KEY tpldirectory (tpldirectory)

mj1919

vot 2013-8-27 11:27
Try this:

Edit install/data/install.sql

that error solved, Thank you!!!!

but new error !

1. INSERT INTO forum_threadprofile (`id`, `name`, `template`, `global`) VALUES (1, lang('update','default_layout'), 'a:2:{s:4:"left";s:399:"{numbercard} {groupicon}<p>{*}</p>{/groupicon} {authortitle}<p><em>{*}</em></p>{/authortitle} {customstatus}<p class="xg1">{*}</p>{/customstatus} {star}<p>{*}</p>{/star} {upgradeprogress}<p>{*}</p>{/upgradeprogress} <dl class="pil cl"> <dt>{baseinfo=credits,1}</dt><dd>{baseinfo=credits,0}</dd> </dl> {medal}<p class="md_ctrl">{*}</p>{/medal} <dl class="pil cl">{baseinfo=field_qq,0}</dl>";s:3:"top";s:82:"<dl class="cl"> <dt>{baseinfo=credits,1}</dt><dd>{baseinfo=credits,0}</dd> </dl>";}', 1);

Copy the Code

No.	File	Line	Code
1	install/update.php	1653	discuz_database::query(%s)
2	source/class/discuz/discuz_database.php	136	db_driver_mysql->query(%s, false, false)
3	source/class/db/db_driver_mysql.php	151	db_driver_mysql->halt(%s, %d, %s)
4	source/class/db/db_driver_mysql.php	218	break()

vot

It is strange.
I see no table_prefix in your query!
Let's try AGAIN update.php!

vot

Stop!
Let me try by myself

vot

It seems the problem is solved.
Verify.

mj1919

vot 2013-8-27 13:54
It seems the problem is solved.
Verify.

Thank you so much!!!!!!!!!!!
yes it solved by your great help!!!!!!!!