Welcome, Guest.
Please login or register.

Welcome to the E-Blah Community!
We would like to welcome you to our community and invite you to register an account or login.
Being a registered member is important, as it gives you several advantages over the normal Guest status. After registering you will be able to download files and images, post messages, and access member-only portions of the forum - just to name a few. Registration is quick and simple, and only takes about a minute of your time.

E-Blah Community  ›  Technical Support  ›  Install Issues  ›  Column 'password' cannot be null
Users Browsing Forum
No Members and 1 Guests

Column 'password' cannot be null  This thread currently has 795 views. Print
2 Pages 1 2 » Recommend Thread
tylermenezes
August 19, 2007, 1:12am Report to Moderator Report to Moderator

Anybody here speak Python? HHHSSSSSSSSSSSSSS!
Posts: 201
Gender: Male
Posts Per Day: 0.21
Reputation: 90.48%
Reputation Score: +19 / -2
Time Online: 1 days 5 hours 56 minutes
Location: Redmond, Washington
Age: 16
I finally got a server with SQL (Nearly Free Speech .Net is highly recommended by me!), and so I'm upgrading my forums to SQL. I get this error on a forum that was running 10.2.5:

Code
Column 'password' cannot be null

INSERT INTO `members` (`userid`,`password`,`sn`,`email`,`posts`,`admintxt`,`avatar`,`personaltxt`,`sex`,`icq`,`aim`,`msn`,`skype`,`sig`,`hidemail`,`registered`,`dob`,`dateformat`,`hideonline`,`sitename`,`siteurl`,`location`,`timeformat`,`status`,`validation`,`ml`,`theme`,`yim`,`lastactive`,`hidesum`,`notify`,`dst`,`avatarupload`,`shownewonly`,`lng`,`showsig`,`ownavatar`,`pmdisable`,`censor`,`pmpopup`,`reputation`,`timeonline`,`md5upgrade`,`blockedusers`,`rndsid`,`avatarsize`,`lastvisit`,`timezone`,`lastpost`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)


This is on a DB with correct login, and all possible permissions. Any help?


Logged Offline
Site Site Private Message Private message
Justin
August 19, 2007, 9:28am Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,075
Gender: Male
Posts Per Day: 6.52
Reputation: 93.40%
Reputation Score: +297 / -21
Time Online: 36 days 23 hours 27 minutes
Location: Tallassee, AL
Age: 22
There is a member that their password field is left blank -- that cannot happen.


I do installs for $25 and upgrades for $20.
Technical support is always free.

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  Portfolio

"But you, O Lord, are a compassionate and gracious God, slow to anger, abounding in love and faithfulness." — Psalm 86:15 NIV
Logged Offline
Site Site Private Message Private message Reply: 1 - 18
tylermenezes
August 19, 2007, 10:55am Report to Moderator Report to Moderator

Anybody here speak Python? HHHSSSSSSSSSSSSSS!
Posts: 201
Gender: Male
Posts Per Day: 0.21
Reputation: 90.48%
Reputation Score: +19 / -2
Time Online: 1 days 5 hours 56 minutes
Location: Redmond, Washington
Age: 16
Hmm, where are the passwords stores (file and line)? I'll check.


Logged Offline
Site Site Private Message Private message Reply: 2 - 18
Justin
August 20, 2007, 8:43am Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,075
Gender: Male
Posts Per Day: 6.52
Reputation: 93.40%
Reputation Score: +297 / -21
Time Online: 36 days 23 hours 27 minutes
Location: Tallassee, AL
Age: 22
In the .dat files.


I do installs for $25 and upgrades for $20.
Technical support is always free.

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  Portfolio

"But you, O Lord, are a compassionate and gracious God, slow to anger, abounding in love and faithfulness." — Psalm 86:15 NIV
Logged Offline
Site Site Private Message Private message Reply: 3 - 18
tylermenezes
August 20, 2007, 1:15pm Report to Moderator Report to Moderator

Anybody here speak Python? HHHSSSSSSSSSSSSSS!
Posts: 201
Gender: Male
Posts Per Day: 0.21
Reputation: 90.48%
Reputation Score: +19 / -2
Time Online: 1 days 5 hours 56 minutes
Location: Redmond, Washington
Age: 16
Hmm, they all seem to be there. They're MD5 encrypted, but not any one is missing the password= line, and they all have something between the pipe chars.


Logged Offline
Site Site Private Message Private message Reply: 4 - 18
Justin
August 21, 2007, 2:49pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,075
Gender: Male
Posts Per Day: 6.52
Reputation: 93.40%
Reputation Score: +297 / -21
Time Online: 36 days 23 hours 27 minutes
Location: Tallassee, AL
Age: 22
So the forum was running 10.2.5?


I do installs for $25 and upgrades for $20.
Technical support is always free.

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  Portfolio

"But you, O Lord, are a compassionate and gracious God, slow to anger, abounding in love and faithfulness." — Psalm 86:15 NIV
Logged Offline
Site Site Private Message Private message Reply: 5 - 18
tylermenezes
August 21, 2007, 3:34pm Report to Moderator Report to Moderator

Anybody here speak Python? HHHSSSSSSSSSSSSSS!
Posts: 201
Gender: Male
Posts Per Day: 0.21
Reputation: 90.48%
Reputation Score: +19 / -2
Time Online: 1 days 5 hours 56 minutes
Location: Redmond, Washington
Age: 16
Yeah, I upgraded everything to 10.2.5 (everything worked) and then to the latest SQL.


Logged Offline
Site Site Private Message Private message Reply: 6 - 18
Justin
August 21, 2007, 4:37pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,075
Gender: Male
Posts Per Day: 6.52
Reputation: 93.40%
Reputation Score: +297 / -21
Time Online: 36 days 23 hours 27 minutes
Location: Tallassee, AL
Age: 22
Did all of your members get put into the database??


I do installs for $25 and upgrades for $20.
Technical support is always free.

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  Portfolio

"But you, O Lord, are a compassionate and gracious God, slow to anger, abounding in love and faithfulness." — Psalm 86:15 NIV
Logged Offline
Site Site Private Message Private message Reply: 7 - 18
tylermenezes
August 21, 2007, 5:26pm Report to Moderator Report to Moderator

Anybody here speak Python? HHHSSSSSSSSSSSSSS!
Posts: 201
Gender: Male
Posts Per Day: 0.21
Reputation: 90.48%
Reputation Score: +19 / -2
Time Online: 1 days 5 hours 56 minutes
Location: Redmond, Washington
Age: 16
None of them. The members table is empty in phpMyAdmin. The tables are all created, though, and some of the other tables (i.e. messages) have content.

If someone wants to look I'll PM them login info.


Logged Offline
Site Site Private Message Private message Reply: 8 - 18
Justin
August 21, 2007, 7:40pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,075
Gender: Male
Posts Per Day: 6.52
Reputation: 93.40%
Reputation Score: +297 / -21
Time Online: 36 days 23 hours 27 minutes
Location: Tallassee, AL
Age: 22
In mysql.pm look for:

Code
	$sth = $dbh->prepare($sql);
	eval { $data = $sth->execute(@query) or error($sth->errstr."\n\n$sql\n\n$count\n\n"); };
	if($@) { error($@); }
	$sth->finish;


And replace with:

Code
	$sth = $dbh->prepare($sql);
	eval { $data = $sth->execute(@query) or error($sth->errstr."\n\n@query\n\n$sql\n\n$count\n\n"); };
	if($@) { error("$@ -- @query"); }
	$sth->finish;


See if that gives any more of the error.


I do installs for $25 and upgrades for $20.
Technical support is always free.

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  Portfolio

"But you, O Lord, are a compassionate and gracious God, slow to anger, abounding in love and faithfulness." — Psalm 86:15 NIV
Logged Offline
Site Site Private Message Private message Reply: 9 - 18
tylermenezes
August 21, 2007, 8:08pm Report to Moderator Report to Moderator

Anybody here speak Python? HHHSSSSSSSSSSSSSS!
Posts: 201
Gender: Male
Posts Per Day: 0.21
Reputation: 90.48%
Reputation Score: +19 / -2
Time Online: 1 days 5 hours 56 minutes
Location: Redmond, Washington
Age: 16
Here's what I get now:

Code
Column 'password' cannot be null

2               1                                 

INSERT INTO `members` (`userid`,`password`,`sn`,`email`,`posts`,`admintxt`,`avatar`,`personaltxt`,`sex`,`icq`,`aim`,`msn`,`skype`,`sig`,`hidemail`,`registered`,`dob`,`dateformat`,`hideonline`,`sitename`,`siteurl`,`location`,`timeformat`,`status`,`validation`,`ml`,`theme`,`yim`,`lastactive`,`hidesum`,`notify`,`dst`,`avatarupload`,`shownewonly`,`lng`,`showsig`,`ownavatar`,`pmdisable`,`censor`,`pmpopup`,`reputation`,`timeonline`,`md5upgrade`,`blockedusers`,`rndsid`,`avatarsize`,`lastvisit`,`timezone`,`lastpost`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)



(I put that update in the insert function, I'm assuming that was correct.)


Logged Offline
Site Site Private Message Private message Reply: 10 - 18
Justin
August 21, 2007, 8:38pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,075
Gender: Male
Posts Per Day: 6.52
Reputation: 93.40%
Reputation Score: +297 / -21
Time Online: 36 days 23 hours 27 minutes
Location: Tallassee, AL
Age: 22
Look at the user ID 2.dat and see what's in it.  Make sure you go to Admin/Rebuild All Members too before the upgrade.


I do installs for $25 and upgrades for $20.
Technical support is always free.

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  Portfolio

"But you, O Lord, are a compassionate and gracious God, slow to anger, abounding in love and faithfulness." — Psalm 86:15 NIV
Logged Offline
Site Site Private Message Private message Reply: 11 - 18
tylermenezes
August 21, 2007, 8:43pm Report to Moderator Report to Moderator

Anybody here speak Python? HHHSSSSSSSSSSSSSS!
Posts: 201
Gender: Male
Posts Per Day: 0.21
Reputation: 90.48%
Reputation Score: +19 / -2
Time Online: 1 days 5 hours 56 minutes
Location: Redmond, Washington
Age: 16
Here's the contents of 2.dat (*'s added for privacy). Anything seem odd about it to you?

Code
rndsid = |1372|1173155339|
lastactive = |1173155339|
pmnew = |1|
lastvisit = |1172715572|
password = |15fc****b914c6400dfe70020ecee226|
sex = |2|
avatarsize = |167|200|
registered = |1155598943|
pmcnt = |1|
posts = |2|
timezone = |-8|
md5upgrade = |1|
sn = |b******d|
avatar = |http://www.mywebsfree.com/mexx/forum/uploads/***************.jpg|
avatarupload = |1|
email = |a*******************e@gmail.com|


Logged Offline
Site Site Private Message Private message Reply: 12 - 18
Justin
August 21, 2007, 8:52pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,075
Gender: Male
Posts Per Day: 6.52
Reputation: 93.40%
Reputation Score: +297 / -21
Time Online: 36 days 23 hours 27 minutes
Location: Tallassee, AL
Age: 22
Nope.  Does the forum work fine before conversion?  Does that member ID work fine too?


I do installs for $25 and upgrades for $20.
Technical support is always free.

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  Portfolio

"But you, O Lord, are a compassionate and gracious God, slow to anger, abounding in love and faithfulness." — Psalm 86:15 NIV
Logged Offline
Site Site Private Message Private message Reply: 13 - 18
tylermenezes
August 21, 2007, 9:02pm Report to Moderator Report to Moderator

Anybody here speak Python? HHHSSSSSSSSSSSSSS!
Posts: 201
Gender: Male
Posts Per Day: 0.21
Reputation: 90.48%
Reputation Score: +19 / -2
Time Online: 1 days 5 hours 56 minutes
Location: Redmond, Washington
Age: 16
I can't confirm that that member ID works right now (I don't have the password), but that member has posted before. The forums work almost fine before conversion. There's a weird glitch with the formatting toolbar not working properly. Nothing member-related, though. Any thoughts?


Logged Offline
Site Site Private Message Private message Reply: 14 - 18
2 Pages 1 2 » Recommend Thread
Print

E-Blah Community  ›  Technical Support  ›  Install Issues  ›  Column 'password' cannot be null

© 2001-2008 E-Blah
About Us - Contact