1
pinchecl
Help, Please
  • 2012/11/30 10:49

  • pinchecl

  • Friend of XOOPS

  • Posts: 193

  • Since: 2005/4/22


I have xoops 2.5.5 installed. This morning I uninstalled the weblinks module but that resulted in (debug is on) this page:

None All Errors (1) Deprecated (3) Queries (37) Blocks (12) Extra (2) Timers(4)
Forum Topic Replies Views Last Post
Errors
Notice: Use of undefined constant servicename - assumed 'servicename' in file /modules/videotube/blocks/vp_featured_h.php line 98
Deprecated
'Database::getInstance();' is deprecated since XOOPS 2.5.4, please use 'XoopsDatabaseFactory::getDatabaseConnection();' instead.
'Database::getInstance();' is deprecated since XOOPS 2.5.4, please use 'XoopsDatabaseFactory::getDatabaseConnection();' instead.
Deprecated function 'mod_getUnameFromIds', use XoopsUserUtility directly.
Queries
0.000100 - SET NAMES 'utf8'
0.000055 - SET SQL_BIG_SELECTS = 1
0.000132 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
0.000206 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '6ee0c6c797ddeceaa7d15f62a70b5500'
0.000242 - SELECT * FROM users WHERE uid = '1'
0.000068 - SELECT * FROM modules WHERE dirname = 'iplog'
0.000069 - SELECT * FROM config WHERE (conf_modid = '69' AND conf_catid = '0') ORDER BY conf_order ASC
0.007311 - SELECT COUNT(*) FROM `iplog_log`
0.000452 - SELECT * FROM `iplog_log` WHERE session_id = '6ee0c6c797ddeceaa7d15f62a70b5500' ORDER BY `ip_id` DESC LIMIT 0, 1
4.579383 - UPDATE `iplog_log` SET `end` = 1354272108, `online` = 4632 WHERE `ip_id` = '190680'
6.961247 - DELETE FROM iplog_log WHERE end <= '1353667312'
0.000278 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
0.000121 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
0.000162 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,-1) AND b.bid IN (149,148,147,146,145,144,143,142,141,134,90,89,88,87,20,18,16,15,14,13,12,9,8,7,5,3,2,1,135,214,133,132,79,116,39,234,231,151,150,216,245,215,217,218,247,248,249,236,230,17,251,11,10,233,190,250,227,232,235,152,153,154,155,156,228,237,246,253,252,229,186,213,221,222,223,224,238,239,240,241,243,244) ORDER BY b.weight, m.block_id
0.000159 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_search.html') ORDER BY tpl_refid
0.000084 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
0.001882 - SELECT * FROM `users` WHERE last_login > '1354185720'
0.000195 - SELECT * FROM smiles
0.000231 - SELECT COUNT(*) FROM priv_msgs WHERE (read_msg = '0' AND to_userid = '1')
0.000098 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
0.000138 - SELECT id, uid, date, code, title, artist, views, thumb, service, servicename FROM vp_videos WHERE id =62
0.000108 - SELECT * FROM users WHERE uid=1
0.000088 - SELECT id, uid, date, code, title, artist, views, thumb, service, servicename FROM vp_videos WHERE id =60
0.000093 - SELECT * FROM users WHERE uid=1
0.000086 - SELECT id, uid, date, code, title, artist, views, thumb, service, servicename FROM vp_videos WHERE id =59
0.000106 - SELECT * FROM users WHERE uid=1
0.000097 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'featured_block_h.html') ORDER BY tpl_refid
0.000095 - SELECT * FROM modules WHERE dirname = 'shoutbox'
0.000100 - SELECT * FROM config WHERE (conf_modid = '7') ORDER BY conf_order ASC
0.000160 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'shoutbox_block.html') ORDER BY tpl_refid
0.000215 - SELECT * FROM modules WHERE dirname = 'newbb'
0.000130 - SELECT * FROM config WHERE (conf_modid = '6') ORDER BY conf_order ASC
0.000155 - SELECT `forum_id`, `cat_id`, `forum_type` FROM `bb_forums` WHERE (1 = '1') ORDER BY forum_order ASC
0.000073 - SELECT COUNT(l.groupid) FROM groups_users_link AS l LEFT JOIN group_permission AS p ON p.gperm_groupid=l.groupid WHERE l.uid=1 AND p.gperm_modid = '1' AND p.gperm_name = 'module_admin' AND p.gperm_itemid = '6'
0.001550 - 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 bb_posts AS p LEFT JOIN bb_topics AS t ON t.topic_last_post_id=p.post_id LEFT JOIN bb_forums AS f ON f.forum_id=t.forum_id WHERE 1=1 AND t.forum_id IN (9,19,18,17,16,15,14,13,12,5,11,10,20) AND t.approved = 1 AND p.post_time>1323168121 AND p.approved=1 ORDER BY p.post_time DESC LIMIT 0, 12
0.000068 - SELECT uid, uname, name FROM users WHERE level > 0 AND uid IN(2,1114,18,761,1225)
0.000086 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'newbb_block.html') ORDER BY tpl_refid
Total: 37
Blocks
Search: Not cached
Custom Block (HTML): Not cached
Custom Block (PHP): Not cached
Sign-in with LinkedIN: Not cached
Custom Block (HTML): Not cached
Custom Block (Auto Format + smilies): Not cached
User Menu: Not cached
Custom Block (Auto Format + smilies): Not cached
Featured Videos H: Not cached
Login: Not cached
Shoutbox: Not cached
Recent Replied Topics: Not cached
Total: 12
Extra
Included files: 110 files
Memory usage: 6254080 bytes
Timers
XOOPS took 12.823 seconds to load.
XOOPS Boot took 0.038 seconds to load.
Module init took 12.683 seconds to load.
XOOPS output init took 0.102 seconds to load.

I cant do anything anymore as the admin page just gives me the menu and for the rest just the debug information:
'Database::getInstance();' is deprecated since XOOPS 2.5.4, please use 'XoopsDatabaseFactory::getDatabaseConnection();' instead.
'Database::getInstance();' is deprecated since XOOPS 2.5.4, please use 'XoopsDatabaseFactory::getDatabaseConnection();' instead.
Queries
0.000131 - SET NAMES 'utf8'
0.000065 - SET SQL_BIG_SELECTS = 1
0.000173 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
0.000287 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '6ee0c6c797ddeceaa7d15f62a70b5500'
0.000110 - SELECT * FROM users WHERE uid = '1'
0.000666 - UPDATE users SET last_login = '1354271911' WHERE uid = 1
0.000070 - SELECT * FROM modules WHERE dirname = 'iplog'
0.000072 - SELECT * FROM config WHERE (conf_modid = '69' AND conf_catid = '0') ORDER BY conf_order ASC
0.007498 - SELECT COUNT(*) FROM `iplog_log`
0.000579 - SELECT * FROM `iplog_log` WHERE session_id = '6ee0c6c797ddeceaa7d15f62a70b5500' ORDER BY `ip_id` DESC LIMIT 0, 1
6.956159 - UPDATE `iplog_log` SET `end` = 1354271911, `online` = 4435 WHERE `ip_id` = '190680'
0.050342 - DELETE FROM iplog_log WHERE end <= '1353667118'
0.000162 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
0.000087 - SELECT * FROM modules WHERE dirname = 'system'
0.000097 - SELECT * FROM config WHERE (conf_modid = '1') ORDER BY conf_order ASC
0.000095 - SELECT * FROM modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC
0.000091 - SELECT * FROM modules WHERE dirname = 'smartobject'
0.000065 - SELECT * FROM config WHERE (conf_modid = '11') ORDER BY conf_order ASC
0.000117 - SELECT * FROM `profile_field`
0.000068 - SELECT * FROM modules WHERE dirname = 'profile'
0.000150 - SELECT * FROM `profile_field`
0.000076 - SELECT * FROM modules WHERE dirname = 'TDMPicture'
0.000088 - SELECT * FROM modules WHERE dirname = 'protector'
0.000063 - SELECT * FROM modules WHERE mid = 4
0.000068 - SELECT * FROM modules WHERE dirname = 'birthday'
0.001727 - SHOW TABLES
0.000203 - SELECT * FROM weblinks_config2 ORDER BY conf_id ASC
0.000102 - SELECT * FROM weblinks_category WHERE pid=0 ORDER BY orders, cid
Total: 28
Blocks
Total: 0
Extra
Included files: 181 files
Memory usage: 5393612 bytes
Timers
XOOPS took 7.818 seconds to load.
XOOPS Boot took 0.040 seconds to load.
Module init took 7.647 seconds to load.
XOOPS output init took 0.011 seconds to load.
Module display took 0.116 seconds to load.
Page rendering took 0.005 seconds to load.

Please, can anyone help me out?

2
pinchecl
Re: Help, Please
  • 2012/11/30 13:17

  • pinchecl

  • Friend of XOOPS

  • Posts: 193

  • Since: 2005/4/22


I have done a restore and everything looked fine again. However, 15 minutes later everything is bad again

3
trabis
Re: Help, Please
  • 2012/11/30 14:07

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Did you uninstall weblinks in administration or did you delete the folder?
What do you mean with restore?

Looking at the logs:
Quote:

0.000203 - SELECT * FROM weblinks_config2 ORDER BY conf_id ASC
0.000102 - SELECT * FROM weblinks_category WHERE pid=0 ORDER BY orders, cid

It is strange to see this queries if the module is not installed.
Perhaps some module has a weblinks plugin and is trying to run it without checking if the module is active or not.
Try uninstall the module and delete the folder. Also delete xoops and smarty caches.

Good luck.

Oh, and you have a problem with the iplog module. 4 and 6 seconds for a query is not acceptable. Try set up proper index keys for the module tables or simply uninstall the module!!!

4
pinchecl
Re: Help, Please
  • 2012/11/30 14:35

  • pinchecl

  • Friend of XOOPS

  • Posts: 193

  • Since: 2005/4/22


I did uninstall through admin and managed to reinstall before I was locked out so that's why you still see the weblinks module. I indeed notice the IPlog problems but can't do anything at this moment. I restored the backup from the server. It was the last working situation (yesterday). Thanks for the suggestion trabis.

5
Mamba
Re: Help, Please
  • 2012/11/30 14:58

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Quote:
Oh, and you have a problem with the iplog module. 4 and 6 seconds for a query is not acceptable. Try set up proper index keys for the module tables or simply uninstall the module!!!

I also recommend to uninstall ipLog module till it is fixed, as one of my clients had the same experience with 4-6 seconds queries.
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs

6
zyspec
Re: Help, Please
  • 2012/11/30 15:15

  • zyspec

  • Module Developer

  • Posts: 1095

  • Since: 2004/9/21


None of the errors above will cause the problem you're seeing.

Are you sure your server configuration has not changed?

Are you locked out of the 'main' admin control panel or just when trying to administer the weblinks module?

Check to make sure you have the latest versions of all the modules you have installed (weblinks, smartobject, TDMPicture, shoutbox, newbb, Iplog, videotube, birthday, others?) and that they're compatible with the version of XOOPS/MySQL/PHP that you have installed.

Another thing to try - disable Protector module (if installed/enabled). You may be running into issues with filtering that is locking you out...

7
pinchecl
Re: Help, Please
  • 2012/11/30 17:19

  • pinchecl

  • Friend of XOOPS

  • Posts: 193

  • Since: 2005/4/22


Quote:

zyspec wrote:
None of the errors above will cause the problem you're seeing.

Are you sure your server configuration has not changed?

Are you locked out of the 'main' admin control panel or just when trying to administer the weblinks module?

Check to make sure you have the latest versions of all the modules you have installed (weblinks, smartobject, TDMPicture, shoutbox, newbb, Iplog, videotube, birthday, others?) and that they're compatible with the version of XOOPS/MySQL/PHP that you have installed.

Another thing to try - disable Protector module (if installed/enabled). You may be running into issues with filtering that is locking you out...


I'm not sure the sever config has changed, I have posted that question to my host. I'm quite sure I had the latest versions of the modules, protector already was disabled. up until this morning everything worked fine so you might be right about server changes. That or the site somehow has become corrupted. I'm doing a new restore. I may consider rebuilding the whole thing

8
pinchecl
Re: Help, Please
  • 2012/11/30 17:23

  • pinchecl

  • Friend of XOOPS

  • Posts: 193

  • Since: 2005/4/22


as it seems, everything is back to normal for now. still, what may have caused it?

9
pinchecl
Re: Help, Please
  • 2012/12/1 9:42

  • pinchecl

  • Friend of XOOPS

  • Posts: 193

  • Since: 2005/4/22


Problem is getting weirder. This morning I installed wflinks which went fine. I then modified theme.html to show the link in a top menu. Uploaded it and got a blank page as a result and an admin page with just the menu. UNdoing the modification and reupload the theme.html didn't bring things back. uploading an untouched theme.html same results. After all the changes I did a cache clean. I'm rather puzzled as I never had this before.

10
trabis
Re: Help, Please
  • 2012/12/1 13:23

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Perhaps you should check your ftp client.
I use FileZilla and I had to change settings of transfer type from 'Automatic' to 'Binary'. Some times the files were uploaded as ASCII and they would cause blank pages.

Login

Who's Online

380 user(s) are online (266 user(s) are browsing Support Forums)


Members: 0


Guests: 380


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