LeagueCMS
competition management for DragonFly CMS

Database error on installing mcomp

The public support form for mComp, online gaming Competition Management Software
Reply to topicReply to topic Printer Friendly Page
Forum FAQSearchView unanswered posts

Database error on installing mcomp

Post Posted: Sat Jul 23, 2011 6:17 pm

Hi there

We just bought your mcomp script for our clan league site test.codnordicliga.dk.
Its a clean installation, so i started with a new database for the job and installing dragonfly. So far so good
Now when i try to install the modules for mcomp i get an install error where it says "A database error has occurred The webmaster has been notified of the error"
Now iv tryied this several times, same error each time. Whats wrong, please help

Kaz

Kazoa
Newbie
Newbie
 

Re: Database error on installing mcomp

Post Posted: Sat Jul 23, 2011 6:20 pm

Oh btw should add that installing any other module works just fine.

And some sys info:
CMS Version 9.2.1
PHP Version 5.3.1
MySQL Version 5.1.31-community (client: mysqlnd 5.0.5-dev - 081106 - $Revision: 289630 $)
mcomp-v5.4.1

Kazoa
Newbie
Newbie
 

Re: Database error on installing mcomp

Post Posted: Sat Jul 23, 2011 6:34 pm

Debug content:

SQL Queries:

modules\Common\cpg_inst.php
0.0006 - FAILED LINE 127: SELECT * FROM cms_mod_comment
includes\classes\installer.php
0.0009 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'VERSION', '1.1.1')
0.0004 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'DEMO', '0')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_CMMT', '0')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'CMMT_QUOTE', '1')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'CMMT_REPLY', '1')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'CMMT_DELETE', '0')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'CMMT_SPACER', '5')
0.0005 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'CMMT_MAXNEST', '10')
0.0004 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'CMMT_COLS', '80')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'CMMT_ROWS', '15')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'CMMT_POST', '1')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'CMMT_PRIVATE', '0')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'DATA_HIDE', '1')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'DATA_TEMPHEAD', 'data_head.html')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'DATA_TEMPLINE', 'data_line.html')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'DATA_TEMPCELL', 'data_cell.html')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_DATE', '0')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'DATE_USESTR', '0')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'DATE_USETIM', '1')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'DATE_TIMSEG', '15')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'DATE_EUROPE', '1')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'DATE_TZONE', '1')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'DATE_DST', '3')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'DATE_FORMAT', 'd/m/Y H:i')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_FCSL', '0')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'FCSL_WIDTH', '640')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'FCSL_HEIGHT', '480')
0.0004 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_LBOX', '0')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_SLID', '0')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_TABS', '0')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_RATE', '0')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'RATE_MAX', '5')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'RATE_IMGON', 'rating_on.gif')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'RATE_IMGOFF', 'rating_off.gif')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'RATE_LABEL', '1')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'RATE_SHOW', '1')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'RATE_ALERT', '1')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'RATE_ANON', '0')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_TEXT', '0')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'TEXT_HTML', '0')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_TIPS', '0')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'TIPS_WIDTH', '500')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_TREE', '0')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_UPLD', '0')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'UPLD_PATH', 'uploads/common/')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'UPLD_EXTNS', 'gif,jpg,png')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'UPLD_OVERWR', '1')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'UPLD_RDNAME', '1')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'UPLD_IMAGE', '1')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'UPLD_RESIZE', '1')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'UPLD_PREFIX', 'thumb_')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'UPLD_WIDTH', '128')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'UPLD_HEIGHT', '96')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'JQUERY_CSS', 'jquery-ui-1.8.12.custom.css')
0.0002 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'JQUERY_LIB', 'jquery-1.5.1.min.js')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'JQUERY_UI', 'jquery-ui-1.8.12.custom.min.js')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_CSS', '')
0.0003 - FAILED LINE 142: INSERT INTO cms_config_custom VALUES ('Common', 'LOAD_LIB', 'jquery.bgiframe.min.js,jquery.cookie.js')
includes\classes\blocks.php
0.0004 - LINE 188: SELECT bid, bkey, title, content, url, blockfile, view, refresh, time FROM cms_blocks WHERE active='1' AND bid IN (1,6,9,2,4,5,7,8,3)
includes\cssmainmenu.php
0.0004 - LINE 44: SELECT m.title as link, m.custom_title as title, m.view, m.active, m.inmenu, m.cat_id, m.pos AS linkpos, c.name, c.image, c.pos AS catpos, c.link AS catlnk, c.link_type AS cattype FROM cms_modules AS m LEFT JOIN cms_modules_cat c ON (c.cid = m.cat_id)
0.0003 - LINE 60: SELECT l.title, l.link, l.link_type, l.view, l.active, l.cat_id, l.pos AS linkpos, c.name, c.image, c.pos AS catpos, c.link AS catlnk, c.link_type AS cattype FROM cms_modules_links AS l LEFT JOIN cms_modules_cat c ON (c.cid = l.cat_id)
blocks\block-CPG_Main_Menu.php
0.0004 - LINE 44: SELECT m.title as link, m.custom_title as title, m.view, m.active, m.inmenu, m.cat_id, m.pos AS linkpos, c.name, c.image, c.pos AS catpos, c.link AS catlnk, c.link_type AS cattype FROM cms_modules AS m LEFT JOIN cms_modules_cat c ON (c.cid = m.cat_id) ORDER BY m.pos
0.0003 - LINE 54: SELECT l.title, l.link, l.link_type, l.view, l.active, l.cat_id, l.pos AS linkpos, c.name, c.image, c.pos AS catpos, c.link AS catlnk, c.link_type AS cattype FROM cms_modules_links AS l LEFT JOIN cms_modules_cat c ON (c.cid = l.cat_id) ORDER BY l.pos
blocks\block-Survey.php
0.0003 - LINE 27: SELECT poll_id, poll_title, voters, anonymous FROM cms_poll_desc WHERE artid=0 ORDER BY poll_id DESC LIMIT 0,1
0.0002 - LINE 47: SELECT COUNT(*) FROM cms_poll_check WHERE user_id='2' AND poll_id='1'
0.0003 - LINE 49: SELECT option_text, vote_id, option_count FROM cms_poll_data WHERE poll_id='1' AND option_text!='' ORDER BY vote_id
0.0003 - LINE 128: SELECT COUNT(*) FROM cms_pollcomments WHERE poll_id='1'
blocks\block-User_Info.php
0.0003 - LINE 29: SELECT s.uname, s.module, s.url, u.user_allow_viewonline FROM cms_session AS s LEFT JOIN cms_users AS u ON u.username=s.uname WHERE guest=0 OR guest=2 ORDER BY s.uname
0.0002 - LINE 30: SELECT uname, module, url FROM cms_session WHERE guest=1 OR guest=3
0.0003 - LINE 99: SELECT COUNT(*) FROM cms_users WHERE user_regdate>='1311368400'
0.0003 - LINE 101: SELECT COUNT(*) FROM cms_users WHERE user_regdate<'1311368400' AND user_regdate>='1311282000'
0.0003 - LINE 105: SELECT username FROM cms_users WHERE user_active = 1 AND user_level > 0 ORDER BY user_id DESC LIMIT 1
0.0003 - LINE 107: SELECT COUNT(*) FROM cms_users WHERE user_id > 1 AND user_level > 0
0.0002 - LINE 134: SELECT a.uname, u.user_id FROM cms_session AS a LEFT JOIN cms_users AS u ON u.username = a.uname WHERE guest = 2 ORDER BY a.uname
modules\coppermine\include\load.inc
0.0003 - LINE 74: SELECT prefix, dirname FROM cms_cpg_installs ORDER BY cpg_id
includes\coppermine\init.inc
0.0005 - LINE 52: SELECT * FROM cms_cpg_config
0.0004 - LINE 72: SELECT * FROM cms_cpg_usergroups WHERE group_id = 2
blocks\block-CPG_Stats.php
0.0004 - LINE 37: SELECT custom_title FROM cms_modules WHERE title='coppermine'
includes\coppermine\functions.inc
0.0002 - LINE 98: SELECT count(*) FROM cms_cpg_albums
0.0002 - LINE 98: SELECT count(*) FROM cms_cpg_pictures
0.0003 - LINE 98: SELECT sum(hits) FROM cms_cpg_pictures
0.0002 - LINE 98: SELECT sum(votes) FROM cms_cpg_pictures
0.0003 - LINE 98: SELECT count(*) FROM cms_cpg_comments
modules\News\admin\adwait.inc
0.0004 - LINE 19: SELECT COUNT(*) FROM cms_queue
modules\coppermine\admin\adwait.inc
0.0003 - LINE 19: SELECT prefix FROM cms_cpg_installs WHERE dirname = 'coppermine'
0.0002 - LINE 20: SELECT dirname FROM cms_cpg_installs WHERE cpg_id=1
0.0002 - LINE 22: SELECT COUNT(*) FROM cms_cpg_pictures WHERE approved=0
includes\cmsinit.inc
Warning line 270: Cannot modify header information - headers already sent by (output started at J:\Websites\codnordicliga.dk\includes\cmsinit.inc:84)
Warning line 271: Cannot modify header information - headers already sent by (output started at J:\Websites\codnordicliga.dk\includes\cmsinit.inc:84)
Warning line 273: Cannot modify header information - headers already sent by (output started at J:\Websites\codnordicliga.dk\includes\cmsinit.inc:84)
Warning line 276: Cannot modify header information - headers already sent by (output started at J:\Websites\codnordicliga.dk\includes\cmsinit.inc:84)
Warning line 277: Cannot modify header information - headers already sent by (output started at J:\Websites\codnordicliga.dk\includes\cmsinit.inc:84)
Warning line 278: Cannot modify header information - headers already sent by (output started at J:\Websites\codnordicliga.dk\includes\cmsinit.inc:84)
modules\Common\cpg_inst.php
Warning line 46: mkdir() [function.mkdir]: File exists
includes\db\db.php
CMS Warning line 75: On /admin.php?op=modules&install=Common While executing query "CREATE TABLE cms_mod_cmmt_data (cmmt_id INT(11) NOT NULL auto_increment, cmmt_pid INT(11) NOT NULL default '0', cmmt_module VARCHAR(100) NOT NULL default '', cmmt_page TINYINT(2) NOT NULL default '1', cmmt_key VARCHAR(100) NOT NULL default '', cmmt_link VARCHAR(255) NOT NULL default '', cmmt_user INT(11) NOT NULL default '0', cmmt_ip VARCHAR(32) NOT NULL default '', cmmt_time INT(11) NOT NULL default '0', cmmt_text TEXT NOT NULL default '', cmmt_del TINYINT(1) NOT NULL default '0', cmmt_private TINYINT(1) NOT NULL default '0', PRIMARY KEY (cmmt_id), KEY cmmt_module (cmmt_module,cmmt_page,cmmt_key)) TYPE=MyISAM DEFAULT CHARSET=utf8" the following error occured: BLOB/TEXT column 'cmmt_text' can't have a default value In: J:\Websites\codnordicliga.dk\includes\classes\installer.php on line: 61
header.php
Warning line 64: Cannot modify header information - headers already sent by (output started at J:\Websites\codnordicliga.dk\includes\cmsinit.inc:84)
Warning line 66: Cannot modify header information - headers already sent by (output started at J:\Websites\codnordicliga.dk\includes\cmsinit.inc:84)
blocks\block-Languages.php
CMS Warning line 24: Multilingual is off

Kazoa
Newbie
Newbie
 

Re: Database error on installing mcomp

Post Posted: Sun Jul 24, 2011 2:38 pm

OK, one problem with DragonFly is it doesn't back up when an installation fails and that first lot of errors are telling you it's already done part of the installation and you're attempting to do it again having already failed.

What I need you to do is start from scratch again, wipe the database, re-install DragonFly etc. so you're starting from another clean install, and then, when you get the FIRST database error STOP. Come back and tell me what that first error is.

Remember, mComp actually consists of 2 separate modules, one called Common and another called Competition. You must install and activate Common first, then install Competition.

mark
Site Admin
Site Admin
 

Re: Database error on installing mcomp

Post Posted: Tue Aug 09, 2011 9:20 am

Hi Mark

I got it working. but there is an issue with dragonfly using obsolete php functions, and some issues with how datatables are created. I think its all related to witch version of php and MySql server is running. Some of the tables created by leaguecms has issues as well. TEXT fields and such cant be created with a default value and such the installation failes. But i worked around it.
Now i got another issue. On players view the mouseover effect isnt working for players with more than one game registered, if player only has one its fine. Oh yeah btw... it wasnt working at all to start with module couldnt find showguid.html, had to move it to another folder

Please have a look, and thx Kazoa

Kazoa
Newbie
Newbie
 

Re: Database error on installing mcomp

Post Posted: Tue Aug 09, 2011 2:26 pm

- Kazoa
there is an issue with dragonfly using obsolete php functions


Yes, although that's beyond my control. If you turn off debugging in the admin section you won't see the error messages.

- Kazoa
I think its all related to witch version of php and MySql server is running.


Looks like MySQL 5.x in strict mode doesn't like default values on TEXT fields, I'll amend that in the installer.

- Kazoa
On players view the mouseover effect isnt working for players with more than one game registered, if player only has one its fine.


Bug by the looks of it. Please upload the attached file (un-zipped obviously) to "/modules/Competition/includes"

mark
Site Admin
Site Admin
 

Re: Database error on installing mcomp

Post Posted: Tue Aug 09, 2011 9:50 pm

Thx m8

Worked perfectly

Kaz

Kazoa
Newbie
Newbie
 

Re: Database error on installing mcomp

Post Posted: Wed Aug 10, 2011 9:35 am

btw Kazoa, because you weren't logged in to your website account when you purchased mComp you weren't automatically granted access to the private support forum :-

www.leaguecms.co.uk/in...forum&f=15

You should now be able to view that forum. At the top is a sticky thread with a link to the latest version and a changelog. It's currently v5.4.1 but I have v5.5.1 almost ready to go which has a couple of bug fixes and some additional features. It's always a good idea to check that thread if you have issues to see if they've been addressed in a later version.

mark
Site Admin
Site Admin
 
Page 1 of 1



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum