XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / Problem installing Publisher, MySQL version?
Register
21
Peekay
Re: Problem installing Publisher, MySQL version?

  • 2012/3/1 20:31

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


If there's no Xoops debug error, no Smarty error and no PHP error, I generally dig deeper and check my Apache/IIS server logs.

If the button press has made a server request of any sort, you should see what's happening to it.

There is also a MySQL general query log... but that's too deep for me!
A thread is for life. Not just for Christmas.
22
bjuti
Re: Problem installing Publisher, MySQL version?

  • 2012/3/3 16:11

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Mamba: I have no RMCommon installed on this site, and I'll turn off security stuff when I upload site to the server, tis is localhost :)

Renetjuh: There is no need for screenshot, everything looks normal.

This is the query (no errors in Xoops debug):

Quote:
0.000405 - SET NAMES 'utf8'
0.000204 - SET SQL_BIG_SELECTS = 1
0.001105 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
0.000664 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 't727m9lr6sislkn312bq1o5837'
0.000341 - SELECT * FROM users WHERE uid = '1'
0.000689 - SELECT * FROM modules WHERE dirname = 'publisher'
0.001468 - SELECT * FROM config WHERE (conf_modid = '3') ORDER BY conf_order ASC
0.000777 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
0.000958 - SELECT * FROM modules WHERE dirname = 'system'
0.001089 - SELECT * FROM config WHERE (conf_modid = '1') ORDER BY conf_order ASC
0.000764 - SELECT * FROM modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC
0.000740 - SELECT * FROM modules WHERE dirname = 'news'
0.000420 - SELECT * FROM groups
0.000526 - SELECT * FROM groups WHERE (group_type = 'Admin')
0.001555 - SELECT * FROM groups
0.001602 - SELECT * FROM `publisher_categories` ORDER BY weight ASC
0.001933 - SELECT * FROM group_permission WHERE (gperm_modid = '3')
0.001101 - SELECT * FROM group_permission WHERE (gperm_name = 'editors' AND gperm_modid = '3' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
0.000930 - SELECT * FROM group_permission WHERE (gperm_name = 'category_read' AND gperm_itemid = '0' AND gperm_modid = '3')
0.000540 - SELECT * FROM group_permission WHERE (gperm_name = 'item_submit' AND gperm_itemid = '0' AND gperm_modid = '3')
0.000561 - SELECT COUNT(*) FROM `users`
0.000536 - SELECT * FROM `users` ORDER BY uname ASC LIMIT 0, 200
Total: 22


This is the Extra field:
Quote:
Publisher: INIT MODULE
Publisher: INIT category HANDLER
Publisher: Getting handler 'category'
Publisher: Getting handler 'category'
Publisher: INIT permission HANDLER
Publisher: Getting handler 'permission'
Publisher: INIT groupperm HANDLER
Publisher: Getting handler 'groupperm'
Publisher: INIT CONFIG
Publisher: Getting config 'submit_editor' : tinymce
Publisher: Getting config 'submit_editor_rows' : 35
Publisher: Getting config 'submit_editor_rows' : 35
Publisher: Getting config 'submit_editor_cols' : 60
Publisher: Getting config 'submit_editor_cols' : 60
Publisher: Getting config 'submit_editor_width' : 100%
Publisher: Getting config 'submit_editor_width' : 100%
Publisher: Getting config 'submit_editor_height' : 400px
Publisher: Getting config 'submit_editor_height' : 400px
Publisher: Getting handler 'permission'
Publisher: Getting handler 'permission'
Publisher: Getting handler 'permission'
Publisher: Getting handler 'permission'
Included files: 164 files
Memory usage: 12380776 bytes



This is Apache error log, nothing unusual:
Quote:
[Sat Mar 03 17:04:34 2012] [notice] Apache/2.2.21 (Win64) PHP/5.3.8 configured -- resuming normal operations
[Sat Mar 03 17:04:34 2012] [notice] Server built: Sep 24 2011 19:57:51
[Sat Mar 03 17:04:34 2012] [notice] Parent: Created child process 4100
PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.3.8/ext/php_exif.dll' - The specified module could not be found.\r\n in Unknown on line 0
<br />
<b>Warning</b>: PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.3.8/ext/php_exif.dll' - The specified module could not be found.
in <b>Unknown</b> on line <b>0</b><br />
PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.3.8/ext/php_zip.dll' - The specified module could not be found.\r\n in Unknown on line 0
<br />
<b>Warning</b>: PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.3.8/ext/php_zip.dll' - The specified module could not be found.
in <b>Unknown</b> on line <b>0</b><br />
PHP Deprecated: Directive 'register_globals' is deprecated in PHP 5.3 and greater in Unknown on line 0
<br />
<b>Deprecated</b>: Directive 'register_globals' is deprecated in PHP 5.3 and greater in <b>Unknown</b> on line <b>0</b><br />
PHP Deprecated: Directive 'magic_quotes_gpc' is deprecated in PHP 5.3 and greater in Unknown on line 0
<br />
<b>Deprecated</b>: Directive 'magic_quotes_gpc' is deprecated in PHP 5.3 and greater in <b>Unknown</b> on line <b>0</b><br />
[Sat Mar 03 17:04:34 2012] [notice] Child 4100: Child process is running
[Sat Mar 03 17:04:34 2012] [notice] Child 4100: Acquired the start mutex.
[Sat Mar 03 17:04:34 2012] [notice] Child 4100: Starting 64 worker threads.
[Sat Mar 03 17:04:34 2012] [notice] Child 4100: Starting thread to listen on port 80.
[Sat Mar 03 17:04:34 2012] [notice] Child 4100: Starting thread to listen on port 80.
[Sat Mar 03 17:05:01 2012] [error] [client 127.0.0.1] File does not exist: C:/wamp/www/findrehab/themes/fastpage/images/menu.gif, referer:http://localhost/findrehab/
[Sat Mar 03 17:05:01 2012] [error] [client 127.0.0.1] File does not exist: C:/wamp/www/findrehab/themes/fastpage/images/content_bg.gif, referer:http://localhost/findrehab/
[Sat Mar 03 17:05:01 2012] [error] [client 127.0.0.1] File does not exist: C:/wamp/www/findrehab/icons
[Sat Mar 03 17:05:01 2012] [error] [client 127.0.0.1] File does not exist: C:/wamp/www/findrehab/icons


This is MySql log:
Quote:
120303 17:04:33 [Note] Plugin 'FEDERATED' is disabled.
120303 17:04:33 InnoDB: The InnoDB memory heap is disabled
120303 17:04:33 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120303 17:04:33 InnoDB: Compressed tables use zlib 1.2.3
120303 17:04:33 InnoDB: Initializing buffer pool, size = 128.0M
120303 17:04:33 InnoDB: Completed initialization of buffer pool
120303 17:04:33 InnoDB: highest supported file format is Barracuda.
120303 17:04:34 InnoDB: Waiting for the background threads to start
120303 17:04:35 InnoDB: 1.1.8 started; log sequence number 1595675
120303 17:04:35 [Note] Event Scheduler: Loaded 0 events
120303 17:04:35 [Note] wampmysqld: ready for connections.
Version: '5.5.16-log' socket: '' port: 3306 MySQL Community Server (GPL)


PHP error log is empty.
23
bjuti
Re: Problem installing Publisher, MySQL version?

  • 2012/3/6 11:01

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Any help? Please?
« 1 2 (3)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

227 user(s) are online (121 user(s) are browsing Support Forums)

Members: 0

Guests: 227

more...

Donat-O-Meter

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

Latest GitHub Commits