Current location: Hot Scripts Forums » Programming Languages » PHP » PHP/Mysql Database issue PHP-nuke


PHP/Mysql Database issue PHP-nuke

Reply
  #1 (permalink)  
Old 10-29-05, 10:35 PM
renob renob is offline
New Member
 
Join Date: Oct 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Post PHP/Mysql Database issue PHP-nuke

ok , Short and sweet, i exported my old 7.7 phpnuke database and upgraded my site to another version of nuke. I have some 400+ members id like to keep but when i run the INSERT INTO Query, I get this error
Code:
#1136 - Column count doesn't match value count at row 1
.

Ive tried inserting any missing fields between the 2 verions and running the query again but same error happens.

Any ideas?

Thanx
Reply With Quote
  #2 (permalink)  
Old 10-30-05, 02:30 AM
nugensoftware's Avatar
nugensoftware nugensoftware is offline
Newbie Coder
 
Join Date: Oct 2005
Location: United States
Posts: 96
Thanks: 0
Thanked 0 Times in 0 Posts
you most likely didn't patch/update the database tables to work with the new information. the problem your having is that the SQL used in the new software is requesting either non-existant fields in a table, or attempting to read them as a different "field type".

As an example lets say your old database stored information in a "varchar" field type and could contain both numbers and alphas. The new version of the software only reads that table as numeric information (int) and access's it with mathmatical equations. This would cause a failure since the database itself will not treat varchar as a integer or float numerical value. Varchar is always string in the database servers eyes.

Anyways it might sound complex but the issue you're having is because the database has changed and you most likely missed the field change, addition, or removal. Check the phpnuke site for details about it.
__________________
Nugen Software Inc.
Lead Developer
www.nugensoftware.com

PHP HELP | MySQL HELP | xmlSYNC
Reply With Quote
  #3 (permalink)  
Old 10-31-05, 01:01 PM
renob renob is offline
New Member
 
Join Date: Oct 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Thanx alot for that, the eroor makes more sense that you explained it. Is there any wy to determine where the differences are without having to insert the old users manually?

Thanx again.
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP Form to update a MySQL database? Scoobler PHP 9 09-04-08 01:41 AM
PHP multi-dimensional array sorting issue aqw PHP 2 06-24-05 11:09 PM
Do PHP can make a user base update web site whitout Database? explorer1979 PHP 5 04-23-05 05:08 AM
PHP search database korro Script Requests 0 04-17-05 05:17 AM
PHP/MySQL Web Database Programmer Needed - PAID richardhay Job Offers & Assistance 3 07-16-04 02:21 PM


All times are GMT -5. The time now is 06:18 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.