61
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?



62
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.



63
bjuti
Re: Problem installing Publisher, MySQL version?
  • 2012/3/1 13:51

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Anyone?



64
bjuti
Re: Problem installing Publisher, MySQL version?
  • 2012/2/29 20:40

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


The screen just blink, but there is no interaction. When I refresh the page,I got notice something like: Image upload fail - but I didn't upload any picture.



65
bjuti
Re: Problem installing Publisher, MySQL version?
  • 2012/2/29 16:28

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Mine is localhost

XOOPS Version XOOPS 2.5.4
PHP Version 5.3.8
mySQL Version 5.5.16-log
Server API apache2handler
OS WINNT
safe_mode Off
register_globals On
magic_quotes_gpc On
allow_url_fopen On
fsockopen On
post_max_size 8M
max_input_time 60
output_buffering 1
max_execution_time 30
memory_limit 128M
file_uploads On
upload_max_filesize 2M

and it doesn't work...



66
bjuti
Re: phpMyAdmin doesn´t export big tables
  • 2012/2/29 13:43

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2





67
bjuti
Re: Problem installing Publisher, MySQL version?
  • 2012/2/29 13:38

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Ok, now Publisher installs well, but when i try to create category, and click 'create' nothing happens. There is nothing in debug, xoops or apache.



68
bjuti
Re: Problem installing Publisher, MySQL version?
  • 2012/2/29 9:30

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Hahah really, this is support :)

Tnx all, I\ll test it today and inform you about results :)



69
bjuti
Re: Problem installing Publisher, MySQL version?
  • 2012/2/28 22:18

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Where to change it? In mysql.sql? I've tried to do it, but it's the same.



70
bjuti
Problem installing Publisher, MySQL version?
  • 2012/2/28 13:23

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Hi there,

I have problem installing Publisher module. The error is:

Quote:
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 'TYPE=MyISAM' at line 18


Debug says:

Quote:
0.000537 - CREATE TABLE publisher_categories ( `categoryid` int(11) NOT NULL auto_increment, `parentid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `description` text NOT NULL, `image` varchar(255) NOT NULL default '', `total` int(11) NOT NULL default '0', `weight` int(11) NOT NULL default '1', `created` int(11) NOT NULL default '1033141070', `template` varchar(255) NOT NULL default '', `header` text NOT NULL, `meta_keywords` text NOT NULL, `meta_description` text NOT NULL, `short_url` varchar(255) NOT NULL default '', `moderator` int(6) NOT NULL default '0', PRIMARY KEY (`categoryid`), KEY parentid (parentid) ) TYPE=MyISAM
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 'TYPE=MyISAM' at line 18


MySQL version is 5.5.x, so what should I change in publisher.sql or wherever it is to have working version of Publisher. The version that I try to install is working version on few live sites.

Tnx.




TopTop
« 1 ... 4 5 6 (7) 8 9 10 ... 64 »



Login

Who's Online

246 user(s) are online (163 user(s) are browsing Support Forums)


Members: 0


Guests: 246


more...

Donat-O-Meter

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

Latest GitHub Commits