1
bumbum
downgrading from 2.2.3
  • 2006/2/15 23:08

  • bumbum

  • Just popping in

  • Posts: 99

  • Since: 2004/10/18


hhttps://xoops.org/modules/core/singlefile.php?cid=4&lid=124

I've tried downgrading using this script but unfortunately I'm having great difficulties. It began OK but I can't complete the process.

Now I'm left with 2 buttons (Downgrade User Tables & Downgrade Blocks). When I try to downgrade the user tables I get the following messages.

Message Log
Could not set user_icq field in users table to the value of user_icq field in profile table
Could not set user_from field in users table to the value of user_from field in profile table
Could not set user_sig field in users table to the value of user_sig field in profile table
Could not set user_viewemail field in users table to the value of user_viewemail field in profile table
Could not set user_aim field in users table to the value of user_aim field in profile table
Could not set user_yim field in users table to the value of user_yim field in profile table
Could not set user_msnm field in users table to the value of user_msnm field in profile table
Could not set user_occ field in users table to the value of user_occ field in profile table
Could not set url field in users table to the value of url field in profile table
Could not set bio field in users table to the value of bio field in profile table
Could not set user_intrest field in users table to the value of user_intrest field in profile table
Could not set umode field in users table to the value of umode field in profile table
Could not set uorder field in users table to the value of uorder field in profile table
Could not set notify_method field in users table to the value of notify_method field in profile table
Could not set notify_mode field in users table to the value of notify_mode field in profile table
Could not set user_regdate field in users table to the value of user_regdate field in profile table
Could not set posts field in users table to the value of posts field in profile table
Could not set attachsig field in users table to the value of attachsig field in profile table
Could not set timezone_offset field in users table to the value of timezone_offset field in profile table
Could not set user_mailok field in users table to the value of user_mailok field in profile table
Could not set theme field in users table to the value of theme field in profile table
Could not set actkey field in users table to the value of actkey field in profile table
Could not set last_login field in users table to the value of last_login field in profile table
MySQL Log
Queries
UPDATE xoops_users u, xoops_user_profile p SET u.user_icq = p.user_icq
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.user_from = p.user_from
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.user_sig = p.user_sig
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.user_viewemail = p.user_viewemail
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.user_aim = p.user_aim
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.user_yim = p.user_yim
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.user_msnm = p.user_msnm
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.user_occ = p.user_occ
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.url = p.url
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.bio = p.bio
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.user_intrest = p.user_intrest
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.umode = p.umode
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.uorder = p.uorder
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.notify_method = p.notify_method
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.notify_mode = p.notify_mode
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.user_regdate = p.user_regdate
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.posts = p.posts
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.attachsig = p.attachsig
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.timezone_offset = p.timezone_offset
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.user_mailok = p.user_mailok
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.theme = p.theme
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.actkey = p.actkey
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_users u, xoops_user_profile p SET u.last_login = p.last_login
Error number: 0
Error message: Database update not allowed during processing of a GET request
SHOW COLUMNS FROM xoops_configcategory LIKE 'confcat_modid'
SHOW TABLES LIKE 'xoops_user_profile'
SHOW TABLES LIKE 'xoops_block_instance'
SHOW TABLES LIKE 'xoops_priv_msgs'
Total: 27 queries


Similarly, When I try to downgrade the blocks I get the following messages.

Message Log
Could not drop pageid field from block_module_link table, check MySQL log for details
9 instance fields added to blocks table
Could not delete custom block instances, check MySQL log for details
Could not delete custom block definition from blocks table, check MySQL log for details
Could not update block information with data from instance table, check MySQL log for details
MySQL Log
Queries
DELETE FROM xoops_block_module_link WHERE pageid > 0
Error number: 0
Error message: Database update not allowed during processing of a GET request
SELECT bid FROM xoops_newblocks WHERE show_func='b_system_custom_show'
SELECT bid, count(*) FROM xoops_block_instance WHERE bid != GROUP BY bid HAVING count(*) > 1
Error number: 1064
Error message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY bid HAVING count(*) > 1' at line 1
SELECT * FROM xoops_newblocks b, xoops_block_instance i WHERE b.bid=i.bid AND b.show_func='b_system_custom_show'
SHOW COLUMNS FROM xoops_newblocks LIKE 'func_num'
SHOW COLUMNS FROM xoops_newblocks LIKE 'title'
SHOW COLUMNS FROM xoops_newblocks LIKE 'content'
SHOW COLUMNS FROM xoops_newblocks LIKE 'side'
SHOW COLUMNS FROM xoops_newblocks LIKE 'weight'
SHOW COLUMNS FROM xoops_newblocks LIKE 'visible'
SHOW COLUMNS FROM xoops_newblocks LIKE 'block_type'
SHOW COLUMNS FROM xoops_newblocks LIKE 'c_type'
SHOW COLUMNS FROM xoops_newblocks LIKE 'bcachetime'
SELECT bid FROM xoops_newblocks WHERE show_func='b_system_custom_show'
DELETE FROM xoops_block_instance WHERE bid=
Error number: 0
Error message: Database update not allowed during processing of a GET request
DELETE FROM xoops_newblocks WHERE show_func='b_system_custom_show'
Error number: 0
Error message: Database update not allowed during processing of a GET request
UPDATE xoops_newblocks b, xoops_block_instance i SET b.title=i.title, b.side=i.side, b.weight=i.weight, b.visible=i.visible, b.block_type='M', b.c_type='', b.bcachetime=i.bcachetime WHERE b.bid=i.bid
Error number: 0
Error message: Database update not allowed during processing of a GET request
SHOW COLUMNS FROM xoops_configcategory LIKE 'confcat_modid'
SHOW TABLES LIKE 'xoops_user_profile'
SHOW TABLES LIKE 'xoops_block_instance'
SHOW TABLES LIKE 'xoops_priv_msgs'
Total: 21 queries

I've tried manually executing these commands in MySQL (the ones with errors that is) but get various error messages and after I execute some sucessfully I get more commands to follow. This seems to be an endless process.

None of the blocks on the site are visible and I can't access the admin area. Anybody got any suggestions???

Login

Who's Online

358 user(s) are online (289 user(s) are browsing Support Forums)


Members: 0


Guests: 358


more...

Donat-O-Meter

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

Latest GitHub Commits