1
suisss
stucked on the upd-2.0.18-to-2.3.0 upgrade
  • 2008/9/27 22:29

  • suisss

  • Just popping in

  • Posts: 45

  • Since: 2004/6/20


ok guys,

I take the day to upgrade some sites, in 2 of theme I didn't have any problem.
But in another ine, I get stucked on the upd-2.0.18-to-2.3.0 upgrade, with this message:
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SHOW KEYS FROM `xoops_block_module_link
ALTER TABLE `xoops_block_module_link` DROP KEY `block_id`, DROP KEY `module_id`, ADD PRIMARY KEY (`block_id`, `module_id`)
Error number: 1091
Error message: Can't DROP 'block_id'; check that column/key exists
Total: 3 queries

How can I solve that
PS: I upgrade 2.2.6 to 2.3.0

Thanks

2
jdseymour
Re: stucked on the upd-2.0.18-to-2.3.0 upgrade

Well if it using upd-2.0.18-to-2.3.0 upgrade and you are upgrading from 2.2.6 seems like the wrong upgrade script and that table may not exist. If it does not exist then it cannot drop it.

3
suisss
Re: stucked on the upd-2.0.18-to-2.3.0 upgrade
  • 2008/9/28 5:44

  • suisss

  • Just popping in

  • Posts: 45

  • Since: 2004/6/20


This is note the wrong script because I already make this with another sites.

4
Marco
Re: stucked on the upd-2.0.18-to-2.3.0 upgrade
  • 2008/9/28 7:09

  • Marco

  • Home away from home

  • Posts: 1256

  • Since: 2004/3/15


hum, it seems we still have problems with blocks, even if we fixed few things for final.
we'll check, strange

Do synergy or die.

5
phppp
Re: stucked on the upd-2.0.18-to-2.3.0 upgrade
  • 2008/9/29 3:10

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


Please check if you have MySQL strict mode turned off.
Anyway we will test with strict mode.

6
phppp
Re: stucked on the upd-2.0.18-to-2.3.0 upgrade
  • 2008/9/29 7:08

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


Fixed in SVN:
http://xoops.svn.sourceforge.net/viewvc/xoops?view=rev&revision=2189

7
Anonymous
Re: stucked on the upd-2.0.18-to-2.3.0 upgrade
  • 2008/9/29 8:07

  • Anonymous

  • Posts: 0

  • Since:


Does this mean that the fix is now incorporated into the 2.3.0 download or that it will be incorporated into the next release?

8
phppp
Re: stucked on the upd-2.0.18-to-2.3.0 upgrade
  • 2008/9/29 8:26

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


Will be released in 2.3.1

Login

Who's Online

179 user(s) are online (107 user(s) are browsing Support Forums)


Members: 0


Guests: 179


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits