1
Parafal
Using 2.0.18.1 SQL with new xoops 2.3? Is it possible?
  • 2008/9/29 19:09

  • Parafal

  • Just popping in

  • Posts: 98

  • Since: 2003/6/7 2


Hi,

I'm having some trouble doing the upgrade from 2.0.18 to 2.3.

I would like to know if it would be possible to install a brand new XOOPS 2.3 and make him use my database from 2.0.18.

Can the XOOPS 2.3 be able to update the table and etc from my "old" SQL from 2.0.18?

Maybe the question is st*pid but I'm not a programmer and I use XOOPS since 2003 but this is the hardest upgrade I did. And I'm getting many error.

Thanks
-|Parafal|-

2
Marco
Re: Using 2.0.18.1 SQL with new xoops 2.3? Is it possible?
  • 2008/9/29 19:23

  • Marco

  • Home away from home

  • Posts: 1256

  • Since: 2004/3/15


hello,

yes, this new branch is the fusion of 2 preexistent branches, so that's the hardest fusion process ever made on xoops. And this in a context of PHP4, PHP5, MySQL 4, MySQL 5 and the different settings you can imagine.
Can you explain me were are your problems exactly, so i can help you?
Did you :
- check the release notes about the upgrade steps
- what are the debug messages diplayed?
- etc.
Do synergy or die.

3
Parafal
Re: Using 2.0.18.1 SQL with new xoops 2.3? Is it possible?
  • 2008/9/29 19:36

  • Parafal

  • Just popping in

  • Posts: 98

  • Since: 2003/6/7 2


Hi,

Yes, I did the steps to do the update and my problem started when the update process freezed.

But I was able to enter in my site.
I updated all my modules.
And I found that all the words in portugueses that use é, í, ç, ã was there. I have a square. I tried to correct this manualy but it will be impossible. To many pages.

Using the debug inline I get this:

Quote:

Errors
Notice: Undefined variable: numrows in file /modules/xoopspartners/blocks/partners.php line 86

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Notice: Deprecated function 'mod_getUnameFromIds', user XoopsUserUtility directly. in file /Frameworks/art/functions.user.php line 26

Warning: Class 'XoopsTree' is deprecated, check 'XoopsObjectTree' in tree.php in file /class/xoopstree.php line 45

Queries
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = 'db35130296f29f2f121329624ddcc186'
SELECT * FROM xoops_users WHERE uid = '2'
SELECT * FROM xoops_modules WHERE dirname = 'news'
SELECT * FROM xoops_config WHERE (conf_modid = '3') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 2, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 20
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1)
SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,3,-1) AND b.bid IN (146,144,143,148,147,142,149,145,25,8,16,24,129,119,118,20,17,10,23,133,102,87,63,105,15,79,18,48,6,131,103,65,83,64,9,7,4,1,28,69,5,132,134,117,104,89,88,75,19,14,13,12,11,3,2,150) ORDER BY b.weight,b.bid
SELECT * FROM xoops_xoopspoll_desc WHERE display=1 ORDER BY weight ASC, end_time DESC
SELECT * FROM xoops_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1'))
SELECT * FROM xoops_modules WHERE dirname = 'wfchannel'
SELECT * FROM xoops_config WHERE (conf_modid = '43') ORDER BY conf_order ASC
SELECT CID, pagetitle, defaultpage FROM xoops_wfschannel WHERE defaultpage = '0' AND submenu = 1 AND (publishdate > 0 AND publishdate <= 1222716707) AND (expiredate = 0 OR expiredate > 1222716707) ORDER BY weight
SELECT submenuitem, titlelink FROM xoops_wfslinktous
SELECT submenuitem , titlerefer FROM xoops_wfsrefer
SELECT * FROM xoops_modules WHERE dirname = 'spaw'
SELECT * FROM xoops_groups
SELECT id FROM xoops_partners Where status = 1 ORDER BY hits DESC
SELECT id, url, image, title FROM xoops_partners WHERE id=10
SELECT id, url, image, title FROM xoops_partners WHERE id=4
SELECT id, url, image, title FROM xoops_partners WHERE id=9
SELECT id, url, image, title FROM xoops_partners WHERE id=12
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
SELECT * FROM xoops_config WHERE (conf_modid = '12') ORDER BY conf_order ASC
SELECT `forum_id`, `cat_id`, `forum_type` FROM `xoops_bb_forums` WHERE (1 = '1') ORDER BY forum_order ASC
SELECT COUNT(l.groupid) FROM xoops_groups_users_link AS l LEFT JOIN xoops_group_permission AS p ON p.gperm_groupid=l.groupid WHERE l.uid=2 AND p.gperm_modid = '1' AND p.gperm_name = 'module_admin' AND p.gperm_itemid = '12'
SELECT DISTINCT t.topic_id, t.topic_replies, t.forum_id, t.topic_title, t.topic_views, t.topic_subject, f.forum_name, f.allow_subject_prefix, p.post_id, p.post_time, p.icon, p.uid, p.poster_name FROM xoops_bb_posts AS p LEFT JOIN xoops_bb_topics AS t ON t.topic_last_post_id=p.post_id LEFT JOIN xoops_bb_forums AS f ON f.forum_id=t.forum_id WHERE 1=1 AND t.forum_id IN (1,12,13,14,16,35,19,20,33,11,8,5,2,21,17,15,22,23,7,6,3,24,9,25,26,10,4,27,28,29,30,31,32) AND t.approved = 1 AND p.post_time>1191612707 AND p.approved=1 ORDER BY p.post_time DESC LIMIT 0, 5
SELECT uid, uname, name FROM xoops_users WHERE level > 0 AND uid IN(2,4105,3910)
SELECT COUNT(*) FROM xoops_modules WHERE dirname = 'news'
SELECT COUNT(*) FROM xoops_stories WHERE published=0
SELECT COUNT(*) FROM xoops_modules WHERE dirname = 'mylinks'
SELECT COUNT(*) FROM xoops_mylinks_links WHERE status=0
SELECT COUNT(*) FROM xoops_mylinks_broken
SELECT COUNT(*) FROM xoops_mylinks_mod
SELECT COUNT(*) FROM xoops_modules WHERE dirname = 'mydownloads'
SELECT COUNT(*) FROM xoops_xoopscomments WHERE com_status=1
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_read' AND gperm_groupid IN (1))
SELECT * FROM xoops_xoopscomments WHERE (com_status = '2' AND com_modid IN (56,57,1,6,4,27,12,51,43,38,28,9,5,3,2)) ORDER BY com_created DESC LIMIT 0, 5
SELECT * FROM xoops_modules WHERE hascomments = '1' ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_users WHERE uid = '1271'
SELECT * FROM xoops_users WHERE uid = '149'
SELECT * FROM xoops_users WHERE uid = '878'
SELECT * FROM xoops_modules WHERE dirname = 'pm'
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = '0' AND to_userid = '2')
SELECT COUNT(*) FROM xoops_online WHERE online_uid=2
UPDATE xoops_online SET online_updated=1222716707, online_module = 3 WHERE online_uid = 2
SELECT * FROM xoops_online
SELECT COUNT(*) FROM xoops_online WHERE online_module = '3'
SELECT * FROM `xoops_users` WHERE (level > '0') ORDER BY user_regdate DESC LIMIT 0, 1
SELECT topic_id, topic_title FROM xoops_topics WHERE topic_pid=0 ORDER BY topic_title
SELECT * FROM xoops_topics WHERE topic_pid=3 ORDER BY topic_title
SELECT * FROM xoops_topics WHERE topic_pid=7 ORDER BY topic_title
SELECT * FROM xoops_topics WHERE topic_pid=4 ORDER BY topic_title
SELECT * FROM xoops_topics WHERE topic_pid=6 ORDER BY topic_title
SELECT * FROM xoops_topics WHERE topic_pid=5 ORDER BY topic_title
SELECT * FROM xoops_topics WHERE topic_pid=2 ORDER BY topic_title
SELECT * FROM xoops_topics WHERE topic_pid=8 ORDER BY topic_title
SELECT * FROM xoops_stories WHERE published > 0 AND published <= 1222716707 AND (expired = 0 OR expired > 1222716707) AND ihome=0 ORDER BY published DESC LIMIT 0, 5
SELECT * FROM xoops_topics WHERE topic_id=3
SELECT * FROM xoops_topics WHERE topic_id=3
SELECT * FROM xoops_topics WHERE topic_id=3
SELECT * FROM xoops_topics WHERE topic_id=3
SELECT * FROM xoops_topics WHERE topic_id=3
SELECT * FROM xoops_smiles
SELECT COUNT(*) FROM xoops_stories WHERE published > 0 AND published <= 1222716707 AND (expired = 0 OR expired > 1222716707) AND ihome=0
SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = '3' AND not_category = 'global' AND not_uid = '2') ORDER BY not_id ASC
SELECT * FROM xoops_modules WHERE mid = 3
Total: 71 queries
Blocks
Login: No Cache
Search: No Cache
Polls: No Cache
AntiDoS: No Cache
Custom Block (Auto Format): No Cache
Main Menu: No Cache
Partners: No Cache
Recent Replied Topics: No Cache
Custom Block (HTML): No Cache
Waiting Contents: No Cache
Recent Comments: No Cache
User Menu: No Cache
Who's Online: No Cache
New Members: No Cache
Total: 14 blocks
Extra
Timers
XOOPS took 0.535 seconds to load.
XOOPS Boot took 0.074 seconds to load.
Module init took 0.024 seconds to load.
XOOPS output init took 0.344 seconds to load.
Module display took 0.065 seconds to load.
Page rendering took 0.009 seconds to load.


You can see it directly on my website:

www.airsoftbrasil.com/html/

If you need more information let me know.

Thank you!
-|Parafal|-

4
Parafal
Re: Using 2.0.18.1 SQL with new xoops 2.3? Is it possible?
  • 2008/9/29 19:41

  • Parafal

  • Just popping in

  • Posts: 98

  • Since: 2003/6/7 2


Maybe this can help:
Quote:

XOOPS Version - XOOPS 2.3.0
PHP Version - 5.2.6
MySQL Version - 5.0.45-community-log
Server API Version - cgi-fcgi
OS Version - Linux


safe_mode - Off
register_globals - Off
magic_quotes_gpc - On
allow_url_fopen - On
fsockopen - On
allow_call_time_pass_reference - On
post_max_size - 55M
max_input_time - -1
output_buffering -
max_execution_time - 30
memory_limit - 32M
file_uploads - On
upload_max_filesize - 2M
-|Parafal|-

5
Marco
Re: Using 2.0.18.1 SQL with new xoops 2.3? Is it possible?
  • 2008/9/29 19:42

  • Marco

  • Home away from home

  • Posts: 1256

  • Since: 2004/3/15


this will help you
you can read this too, but it's in french. your problems deals with the fact that you upgrade from a non UTF8 encoded website.
Do synergy or die.

6
Parafal
Re: Using 2.0.18.1 SQL with new xoops 2.3? Is it possible?
  • 2008/9/29 19:44

  • Parafal

  • Just popping in

  • Posts: 98

  • Since: 2003/6/7 2


Merci Marco je vai lire les informations!

Fortunately I can read and speak french.

MERCI!!!
-|Parafal|-

7
Marco
Re: Using 2.0.18.1 SQL with new xoops 2.3? Is it possible?
  • 2008/9/29 19:52

  • Marco

  • Home away from home

  • Posts: 1256

  • Since: 2004/3/15


Do synergy or die.

8
Parafal
Re: Using 2.0.18.1 SQL with new xoops 2.3? Is it possible?
  • 2008/9/29 19:55

  • Parafal

  • Just popping in

  • Posts: 98

  • Since: 2003/6/7 2


Em português melhor ainda!

The only thing is that I keep having this problem here:

Quote:

Errors
Notice: Undefined variable: numrows in file /modules/xoopspartners/blocks/partners.php line 86

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 619

Notice: Deprecated function 'mod_getUnameFromIds', user XoopsUserUtility directly. in file /Frameworks/art/functions.user.php line 26

Warning: Class 'XoopsTree' is deprecated, check 'XoopsObjectTree' in tree.php in file /class/xoopstree.php line 45



Is it ok to leave it like this? Don't need to try to correct it?
-|Parafal|-

9
Marco
Re: Using 2.0.18.1 SQL with new xoops 2.3? Is it possible?
  • 2008/9/29 19:59

  • Marco

  • Home away from home

  • Posts: 1256

  • Since: 2004/3/15


no, those are warning for devs. it tells some function/classes are deprecated.
Do synergy or die.

10
Parafal
Re: Using 2.0.18.1 SQL with new xoops 2.3? Is it possible?
  • 2008/9/29 20:06

  • Parafal

  • Just popping in

  • Posts: 98

  • Since: 2003/6/7 2


Ok, thank you for the help.

I think now everything is ok!

Thanks a lot!
Merci!
Obrigado!
-|Parafal|-

Login

Username:
Password:

Lost Password? Register now!

Who's Online

74 user(s) are online (48 user(s) are browsing Support Forums)


Members: 0


Guests: 74


more...

Donat-O-Meter

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

Latest GitHub Commits