Anyone want to help me with a different CMS? :: Archived

inetbiz

SQL error trying to add downloads

Code::

includes/db/db.php
CMS Warning line 51: On /admin.php?op=Downloads While executing query "insert into nuke_downloads_downloads values (NULL, '7', '0', 'Patch 01 Upgrade to 6.15 from 6.1 or 6.1a', 'http://creforge.com/frs/download.php/10/loaded61apatch01.zip', 'This will upgrade your CRE Loaded 6.1a installation to CRE Loaded 6.15 Many enhancements and bug fixes are found in this release. Currently it has reached the end of life for this product cycle and upgrading to 6.2 is highly recommended.', now(), 'Inetbiz', 'denver@chainreactionweb.com', '0', 'None', 0, 0, 0, '0', '6.1a', 'http://www.creloaded.com')" the following error occured: Column count doesn't match value count at row 1 In: /var/www/vhosts/forums.creloaded.com/httpdocs/modules/Downloads/admin/index.inc on line: 506

Phoenix

Looks like the old download module - the query looks correct.

I suggest you review your nuke_downloads_downloads table structure and delete/add the extra/missing columns (if adding, make sure you add the columns in their correct sequence).

I'd hazard a guess that you had something like the nuke Enhanced downloads module which probably has more/fewer columns than the DF Downloads module needs.

Naturally, you would backup your database tables before doing that Wink

btw, there never was a DF version 9.0.3.5

inetbiz

That's the version that we installed years ago. I'm not sure if they made it for creloaded or what. Our programmers don't have time to fool with this so it's been assigned to me. I will post the table structure here:

Code::

CREATE TABLE `nuke_downloads_downloads` (
  `lid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `desc_short` text NOT NULL,
  `url` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `date` datetime default NULL,
  `name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `submitter` varchar(60) NOT NULL default '',
  `downloadratingsummary` double(6,4) NOT NULL default '0.0000',
  `totalvotes` int(11) NOT NULL default '0',
  `totalcomments` int(11) NOT NULL default '0',
  `filesize` int(11) NOT NULL default '0',
  `version` varchar(10) NOT NULL default '',
  `homepage` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`lid`),
  KEY `lid` (`lid`),
  KEY `cid` (`cid`),
  KEY `sid` (`sid`),
  KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=236 ;

NanoCaiordo

Code::

`desc_short` text NOT NULL,

inetbiz

Now a new one arrived in email:

Code::

On /Forums/posting.html
While executing query "INSERT INTO nuke_bbtopics (topic_title, topic_description, topic_descmod, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote, icon_id) VALUES ('Desperate ~ need 'Add comments to your order' text', 'Missing 'add comments to order' text in checkout', '', 5890, 1187319149, 23, 0, 0, 0, 0)"

the following error occured: 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 'add comments to order' text in checkout', '', 5890, 1187319149, 23, 0, 0, 0, 0)' at line 1

In: /var/www/vhosts/forums.creloaded.com/httpdocs/includes/phpBB/functions_post.php on line: 138

NanoCaiordo

inetbiz are you really running Dragon 9.0.3.5?
also someone must have modified those files, please consider to reopload all original files or upgrade to a recent version.

rlgura

Uh, what's CRELoaded? Looks like a totally different CMS...

Mel

inetbiz wrote:

That's the version that we installed years ago. I'm not sure if they made it for creloaded or what. Our programmers don't have time to fool with this so it's been assigned to me. I will post the table structure here:

Subject heading changed to fit topic.
Moved to Chit Chat.
FYI: Support Forums are ONLY for Dragonfly CMS.

inetbiz

Why is this moved to chit chat? I still need help

CatchImran

Simply because you aren't using Dragonfly and this is a forums related to Dragonfly and not any other CMS. Hope that helps explain the moving of the topic.

inetbiz · Posted: Sat Aug 18, 2007 5:12 pm Post subject: db coallation

db coallation

Code::

On /admin.php
While executing query "DELETE FROM nuke_session WHERE host_addr=' p/' AND guest=1"

the following error occured: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

In: /var/www/vhosts/forums.creloaded.com/httpdocs/includes/classes/cpg_member.php on line: 121

Mel

From our dev:

NanoCaiordo wrote:

inetbiz are you really running Dragon 9.0.3.5?
also someone must have modified those files, please consider to reopload all original files or upgrade to a recent version.

If you are indeed needing help with Dragonfly CMS, please provide the correct Version and build. You were asked this before. Confused

You choose to ignore it.
This information is needed to be able to properly assist you, since the only information you have provided us with is NOT a dragonfly cms.

Thanks

Phoenix

CREloaded appears to be a dragonfly site that has been fiddled with and left to decay - you should contact the person who claimed responsibility for it - perhaps he can sort out the mess and upgrade it to a more secure version.

LoonyLuke wrote:

btw your site is not running LEO correctly all pages should be html (like my site: www.CRELoaded.com)

Luke

There is no version 9.0.3.5