 | [Solved] problem when registering |  |
 Posted: 06/06/2007 9:44 AM |
 |
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 8:42 AM
Location: Birmingham, UK.
|
|
|
|
|
 |
you just get this
| Code:
|
Could not insert data into users table
DEBUG MODE
SQL Error : 1136 Column count doesn't match value count at row 1
INSERT INTO phpbb_users (user_id, username, user_regdate, user_password,user_email, user_topic_moved_mail, user_topic_moved_pm, user_topic_moved_pm_notify, user_topic_moved_mail, user_topic_moved_pm, user_topic_moved_pm_notify, user_icq, user_website, user_occ, user_from, user_from_flag, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_postspp, user_topicspp, user_allowhtml, user_allowbbcode, user_showdescriptions, user_showtooltips, user_tooltips_parse, user_tooltips_static, user_toolimg_width, user_toolimg_height, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_gender, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (10, 'Test', 1181140900, 'd3630410c51e60941a9001a46871070e', 'christopher-powell@hotmail.com', 0, 1, 1, '', '', '', '', 'blank.gif', '', '', '', '', 0, 0, '', '', '', 1, 1, '', '', 0, 1, 0, 0, 0, 0, 250, 250, 1, 0, 1, 1, 1, 0, 'D M d, Y g:i a', 'english', 1, 0, 1, 0, '7cbdea14eaad82ed6')
Line : 809
File : usercp_register.php
|
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem when registering | |
| Posted: 06/06/2007 1:38 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 8:42 AM
Location: Birmingham, UK.
|
|
|
|
|
|
At a guess it's something to do with this mod being installed Moved_Topic_Message
Just after I sent a mass email via the djpassion.co.uk forums asking others to register as well, typical :violent1 |
|
|
|
|
| Back to Top |
|
|
| Re: problem when registering | |
| Posted: 06/06/2007 4:11 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 3:42 AM
Location: St Pete, FL
|
|
|
|
|
|
If you're using Dreamweaver to edit your forum files, you should stop before you really make a mess of them. Dreamweaver adds double-spacing to every file that you edit. Today, I have had to correct your overall_header.tpl twice and once yesterday...
The problem was with the Moved_Topic_Message MOD. The following fields were added to the SQL query twice:
| Code:
|
|
, user_topic_moved_mail, user_topic_moved_pm, user_topic_moved_pm_notify
|
It should be working correctly now...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem when registering | |
| Posted: 06/06/2007 4:18 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 8:42 AM
Location: Birmingham, UK.
|
|
|
|
|
|
Ok, I'm not using Dreamweaver though I'm using the Araneae editor that a guy recommended me to use over at phpbb.com. I didn't realize it was adding double spacing. Do you have a text editor to recommend as I don't know of any other good ones...?
I'll look into the Araneae text editor options and see if there’s a way of turning of double spacing
I've also made a backup of the usercp_register.php file
Thanks man  |
|
|
|
|
| Back to Top |
|
|
| Re: problem when registering | |
| Posted: 06/06/2007 4:56 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 3:42 AM
Location: St Pete, FL
|
|
|
|
|
|
I've seen Dreamweaver do the same thing, that's why I suspected that its what you were using. I've seen some pretty messed up code on sites where the admin was extensively using Dreamweaver to edit their files. I think your files would be equally messed up in short order if you continue using Araneae to edit your files...
I highly recommend using 1st Page 2000. 1st Page 2000 is free and has been one of the most popular html editors for years. I don't think much of 1st Page 2006 though...
Also, UltraEdit is a good and professional text editor. It is not free though. UltraEdit is very good for comparing files to try to find out what might be causing a problem...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem when registering | |
| Posted: 06/06/2007 5:06 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 8:42 AM
Location: Birmingham, UK.
|
|
|
|
|
|
Ok, as I said in the other thread about me not being to keen on using 1st Page 2000 I'll give that a miss.
I'll try UltraEdit for now. No doubt I'll be given some good file editing software when I start at my new job next week anyway. |
|
|
|
|
| Back to Top |
|
|
| Re: problem when registering | |
| Posted: 06/06/2007 5:18 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 3:42 AM
Location: St Pete, FL
|
|
|
|
|
|
Oh, you're the first I've talked to who didn't like 1st Page. What was it that you didn't like about it? UltraEdit is a very professional text editor, so you can't go wrong using it either...
|
|
|
|
|
| Back to Top |
|
|
| Re: problem when registering | |
| Posted: 06/06/2007 5:29 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 8:42 AM
Location: Birmingham, UK.
|
|
|
|
|
|
| Nightrider wrote:
|
|
Oh, you're the first I've talked to who didn't like 1st Page. What was it that you didn't like about it?
|
Everything heh 
| Nightrider wrote:
|
UltraEdit is a very professional text editor, so you can't go wrong using it either...
|
Yeah I will have download UltraEdit and give it a try. I'm using dial-up at the moment though and it would take to long to down 10MB! I will download it when broadband line is back on which hopefully should be tomorrow 8)
For now though could possibly take a look at Araneae for me and see if there's a way to stop the double spacing etc. I really like this editor, I've just got used to it. The FIND and REPLACE is very handy. All the coding is laid out good too. See what you think of it Nightrider
http://www.djpassions.com/araneae_setup.rar |
|
|
|
|
| Back to Top |
|
|
| Re: problem when registering | |
| Posted: 06/06/2007 5:51 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 3:42 AM
Location: St Pete, FL
|
|
|
|
|
|
I just edited your overall_header.tpl file and saved it using Araneae and it did not add the extra double-spacing. I'm using the default settings. Is there something else that you are using that might be causing this problem???
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem when registering | |
| Posted: 06/06/2007 6:03 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 8:42 AM
Location: Birmingham, UK.
|
|
|
|
|
|
Hmmm, I don't know then. I've been using Araneae for a good 5 weeks now and you've only started seeing the double spacing in my phpbb files for the past few days or so
All I'm using is Araneae though. Could be your editor then |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
