| Topic Archived |
View previous topic :: View next topic |
| Author |
Message |
Dizfunkshunal
Platinum Supporter
 Offline
Joined: Mar 23, 2006
Posts: 2064
|
 Posted: Sat Aug 25, 2007 9:20 pm
Post subject: submit news error |
|
ok background
site conversion from phpnuke
started out with nuke upgraded to DF 9.0.6.1 (no problems)
then upgraded to 9.1.2.6cvs
Had a few problems with modules not showing as installed easy fix added entrys into the modules table for them.
now when trying to submit news as admin get this error :
| Code:: |
includes/db/db.php
* CMS Warning line 75: On /admin.php?op=News While executing query "INSERT INTO nuke_stories VALUES (DEFAULT, '0', 'Dizfunkshunal', 'Testing', 1188094620, 'Testing 123 Hello', '', '0', '0', '0', 'Dizfunkshunal', '', '1', 'english', '0', '0', '0', '0', '0', '', '0')" the following error occured: Column count doesn't match value count at row 1 In: /home/elite/public_html/modules/News/admin/index.inc on line: 75 |
and when trying to approve an article that is waiting get the same error.
any ideas how to fix.?
_________________
Diz Web Design Status: Open (Use of resources requires registration.)
Dizfunkshunal's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Multiple Setups
|
|
| Back to top |
|
 |
DJ Maze
Developer
Offline
Joined: Apr 19, 2004
Posts: 5683
Location: http://tinyurl.com/5z8dmv
|
Posted: Sat Aug 25, 2007 10:41 pm
Post subject: Re: submit news error |
|
could you provide a mysql dump of the current structure of that table?
Admin -> General -> Database
- select 'nuke_stories'
- uncheck 'Save Data'
- uncheck 'Include DROP statement'
- uncheck 'Use GZIP compression'
- click the [go] button
This will give you the structure only (create table statement)
DJ Maze's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Fedora 15 / 2.2.22 / 5.5.20 / 5.3.10 / CVS
|
|
| Back to top |
|
|
Dizfunkshunal
Platinum Supporter
Offline
Joined: Mar 23, 2006
Posts: 2064
|
Posted: Sun Aug 26, 2007 12:11 am
Post subject: Re: submit news error |
|
Here you go
_________________
Diz Web Design Status: Open (Use of resources requires registration.)
Dizfunkshunal's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Multiple Setups
|
|
| Back to top |
|
|
DJ Maze
Developer
Offline
Joined: Apr 19, 2004
Posts: 5683
Location: http://tinyurl.com/5z8dmv
|
Posted: Sun Aug 26, 2007 9:21 am
Post subject: Re: submit news error |
|
Something went wrong  it's the data not the create structure.
DJ Maze's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Fedora 15 / 2.2.22 / 5.5.20 / 5.3.10 / CVS
|
|
| Back to top |
|
|
Dizfunkshunal
Platinum Supporter
Offline
Joined: Mar 23, 2006
Posts: 2064
|
Posted: Sun Aug 26, 2007 1:58 pm
Post subject: Re: submit news error |
|
what do you men the data? The content of the news article?
_________________
Diz Web Design Status: Open (Use of resources requires registration.)
Dizfunkshunal's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Multiple Setups
|
|
| Back to top |
|
|
Dizfunkshunal
Platinum Supporter
Offline
Joined: Mar 23, 2006
Posts: 2064
|
Posted: Sun Aug 26, 2007 2:22 pm
Post subject: Re: submit news error |
|
in the table nuke_stories is there suppost to be a rating_ip. I compared there table to the same one on my sites database that is the only differance I see
_________________
Diz Web Design Status: Open (Use of resources requires registration.)
Dizfunkshunal's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Multiple Setups
|
|
| Back to top |
|
|
Dizfunkshunal
Platinum Supporter
Offline
Joined: Mar 23, 2006
Posts: 2064
|
Posted: Sun Aug 26, 2007 2:26 pm
Post subject: Re: submit news error |
|
I tested it. I removed the rating_ip from table nuke_stories now I can post new News stories with no problems.
_________________
Diz Web Design Status: Open (Use of resources requires registration.)
Dizfunkshunal's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Multiple Setups
|
|
| Back to top |
|
|
Phoenix
• Many Posts •
Offline
Joined: Apr 19, 2004
Posts: 8799
Location: Netizen
|
Posted: Sun Aug 26, 2007 2:29 pm
Post subject: Re: submit news error |
|
There is no column rating_ip in DF - delete it and you problem should go away.
Backup first if you wish to be certain.
_________________
• DonationsPro for DragonflyCMS, SMF, MyBB, vBulletin •
Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
|
|
| Back to top |
|
|
Dizfunkshunal
Platinum Supporter
Offline
Joined: Mar 23, 2006
Posts: 2064
|
Posted: Sun Aug 26, 2007 2:36 pm
Post subject: Re: submit news error |
|
lol thanks thats exactly what I did. Altho i had not read your post prior to doing it. Yes I always back up before I make a change I am not sure about lol
_________________
Diz Web Design Status: Open (Use of resources requires registration.)
Dizfunkshunal's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Multiple Setups
|
|
| Back to top |
|
|
Phoenix
• Many Posts •
Offline
Joined: Apr 19, 2004
Posts: 8799
Location: Netizen
|
Posted: Sun Aug 26, 2007 2:53 pm
Post subject: Re: submit news error |
|
hmm, you actually did it before I posted and posted before I got around to submitting 
In reality, there are many queries we still have to amend so that irrelevant columns are ignored. However, I think MySQL strict would still generate an error even if we fixed the queries.
Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
|
|
| Back to top |
|
|
Dizfunkshunal
Platinum Supporter
Offline
Joined: Mar 23, 2006
Posts: 2064
|
Posted: Sun Aug 26, 2007 8:56 pm
Post subject: Re: submit news error |
|
I was just guessing about removing that from the table would fix it. I was actually expecting the whole site to crash when I refreshed the page after dropping it
_________________
Diz Web Design Status: Open (Use of resources requires registration.)
Dizfunkshunal's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Multiple Setups
|
|
| Back to top |
|
|
NanoCaiordo
Developer
Offline
Joined: Jun 29, 2004
Posts: 3878
Location: Melbourne, AU
|
Posted: Mon Aug 27, 2007 12:56 am
Post subject: Re: submit news error |
|
Currently rewriting all queries using a FULL INSERT which will fix your and any future problem cause but them
_________________
.:: I met php the 03 December 2003 :: Unforgettable day! ::.
Linux 64bit / Apache 2.2 / PHP 5.4 / MySQL 5.5.22 / v9, v10
Linux 32bit / Apache 2.2 / PHP 5.3.10 / MySQL 5.5.22 / v9, v10
Windows 64bit / IIS 7.5 / PHP 5.3.10 / MySQL 5.5.22 / v9, v10
NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
mixed
|
|
| Back to top |
|
|
Dizfunkshunal
Platinum Supporter
Offline
Joined: Mar 23, 2006
Posts: 2064
|
Posted: Mon Aug 27, 2007 1:19 am
Post subject: Re: submit news error |
|
very nice let me know if you need a beta tester for it
_________________
Diz Web Design Status: Open (Use of resources requires registration.)
Dizfunkshunal's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Multiple Setups
|
|
| Back to top |
|
|
NanoCaiordo
Developer
Offline
Joined: Jun 29, 2004
Posts: 3878
Location: Melbourne, AU
|
Posted: Mon Aug 27, 2007 3:29 am
Post subject: Re: submit news error |
|
I've finished and all queries within the core and modules that I've found have been updated to the full insert.
_________________
.:: I met php the 03 December 2003 :: Unforgettable day! ::.
Linux 64bit / Apache 2.2 / PHP 5.4 / MySQL 5.5.22 / v9, v10
Linux 32bit / Apache 2.2 / PHP 5.3.10 / MySQL 5.5.22 / v9, v10
Windows 64bit / IIS 7.5 / PHP 5.3.10 / MySQL 5.5.22 / v9, v10
NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
mixed
|
|
| Back to top |
|
|
Jeruvy
Security Team
Offline
Joined: Apr 23, 2004
Posts: 1432
Location: Canada
|
Posted: Mon Aug 27, 2007 5:05 pm
Post subject: Re: submit news error |
|
| NanoCaiordo wrote: |
| I've finished and all queries within the core and modules that I've found have been updated to the full insert. |
Which version please?
_________________
J.
j e r u v y a t y a h o o d o t c o m
Need help? Look here: www.dragonflycms.org/W...d=112.html
Need to chat? Look for me on irc.freenode.net
Jeruvy's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Ubuntu7.10/Debian3.1 - 2.2.3/1.3.37 - 5.0.38/4.0.27 - 5.2.1/4.4.7 - CVS/9.1.2}
|
|
| Back to top |
|
|
|
|
Forum FAQ
Log in to check your private messages
Login
Search
