1
PTlooker
Upgrade mysql.sql file!
  • 2004/1/25 15:14

  • PTlooker

  • Just can't stay away

  • Posts: 447

  • Since: 2003/6/15


Hi!
I have upgraded to mydownloads rc1 but now i have lost all data that i had...i think that i can solve this if i put the older mysql.sql file but that doesnt work...so how can i do?
Thanks in advance!

2
Mithrandir
Re: Upgrade mysql.sql file!

Database tables should only be created or removed in installation/uninstallation procedures.

When updating the module, nothing should change in that module's tables - although the module may stop working properly, if there have been database changes.

the mysql.sql files very rarely hold any data - usually only structure.

3
PTlooker
Re: Upgrade mysql.sql file!
  • 2004/1/25 16:13

  • PTlooker

  • Just can't stay away

  • Posts: 447

  • Since: 2003/6/15


So how can i put all the data appearing on the module again?

4
Mithrandir
Re: Upgrade mysql.sql file!

Are you getting nothing shown? No errors, no nothing?

Check the database to see if the data are still there. Then check a readme/changelog of the module to see if there is an answer there.

If the data are not still in the database... they're gone.

5
PTlooker
Re: Upgrade mysql.sql file!
  • 2004/1/25 19:22

  • PTlooker

  • Just can't stay away

  • Posts: 447

  • Since: 2003/6/15


It seems everything ok with the database...how can i solve this so?
Thanks in advance!

6
Mithrandir
Re: Upgrade mysql.sql file!

Check the database table structure of the module and compare it to the one in the mysql.sql file and see if you have any mis-matches.

Btw. did MySQL debug throw any errors?

7
PTlooker
Re: Upgrade mysql.sql file!
  • 2004/1/25 23:12

  • PTlooker

  • Just can't stay away

  • Posts: 447

  • Since: 2003/6/15


I got this:

Queries
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 1) ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = '44562c1c5e8c9c2edf168b9a46c05088'
SELECT * FROM xoops_users WHERE uid=2
SELECT * FROM xoops_modules WHERE dirname = 'mydownloads'
SELECT * FROM xoops_config WHERE (conf_modid = 27) ORDER BY conf_order ASC
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 3) ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 1, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 4
SELECT b.* FROM xoops_block_module_link m LEFT JOIN xoops_newblocks b ON b.bid=m.block_id LEFT JOIN xoops_group_permission l ON l.gperm_itemid=b.bid WHERE l.gperm_name = 'block_read' AND gperm_modid = 1 AND (l.gperm_groupid=1 OR l.gperm_groupid=2) AND b.isactive=1 AND b.visible=1 AND (m.module_id=0 OR m.module_id=27) ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = 0 AND to_userid = 2)
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'iceLOOK' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'iceLOOK' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT * FROM xoops_modules WHERE (hasmain = 1 AND isactive = 1 AND weight > 0) ORDER BY weight ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = 1 AND (gperm_groupid = 1 OR gperm_groupid = 2))
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'iceLOOK' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'iceLOOK' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_online WHERE online_uid=2
UPDATE xoops_online SET online_updated=1075073047, online_module = 27 WHERE online_uid = 2
SELECT * FROM xoops_online
SELECT COUNT(*) FROM xoops_online WHERE online_module = 27
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'iceLOOK' AND tpl_file = 'system_block_online.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'iceLOOK' AND tpl_file = 'system_block_online.html') ORDER BY tpl_refid
SELECT cid, title, imgurl FROM xoops_mydownloads_cat WHERE pid = 0 ORDER BY title
SELECT COUNT(*) FROM xoops_mydownloads_downloads WHERE status = 1
SELECT d.lid, d.cid, d.title, d.url, d.homepage, d.version, d.size, d.platform, d.logourl, d.status, d.date, d.hits, d.rating, d.votes, d.comments, t.description FROM xoops_mydownloads_downloads d, xoops_mydownloads_text t WHERE d.status = 1 AND d.lid=t.lid ORDER BY date DESC LIMIT 0, 10
SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = 27 AND not_category = 'global' AND not_uid = 2) ORDER BY not_id ASC
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'iceLOOK' AND tpl_file = 'mydownloads_index.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'iceLOOK' AND tpl_file = 'mydownloads_index.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'mydownloads_index.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'iceLOOK' AND tpl_file = 'system_notification_select.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'iceLOOK' AND tpl_file = 'system_notification_select.html') ORDER BY tpl_refid
Total: 32 queries


I dont know what is this "telling" me...can you help me on this?
Thanks in advance!

8
Mithrandir
Re: Upgrade mysql.sql file!

not a whole lot. Is this from a mydownloads page?
Basically, what you look for is an SQL sentence written in red which indicates an error.

How is the structure of the existing tables corresponding with the structure in mysql.sql for mydownloads?

9
PTlooker
Re: Upgrade mysql.sql file!
  • 2004/1/26 1:02

  • PTlooker

  • Just can't stay away

  • Posts: 447

  • Since: 2003/6/15


I have nothing in red there...and about "How is the structure of the existing tables corresponding with the structure in mysql.sql for mydownloads?" I dont know how to compare them...plz give me a help on this..
Thanks in advance!

10
PTlooker
Re: Upgrade mysql.sql file!
  • 2004/1/26 20:23

  • PTlooker

  • Just can't stay away

  • Posts: 447

  • Since: 2003/6/15


Still waiting...

Login

Who's Online

257 user(s) are online (109 user(s) are browsing Support Forums)


Members: 0


Guests: 257


more...

Donat-O-Meter

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

Latest GitHub Commits