 | Re: [Solved] Simple Colour Usergroups |  |
 Posted: 06/24/2007 6:21 PM |
 |
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
 |
|
|
|
Joined: Jan 06, 2006
Local time: 2:11 AM
|
|
|
|
|
 |
Gosh no I haven't a clue! Its like a cache really as those holly sprigs were added to the template then replaced once Christmas was over, so they only exist in the forumsOLD folder - and they've been renamed and are waiting to be used this year 
A slightly OT problem - someone just tried to register and got this error 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_regip, user_icq, user_website, user_occ, user_from, user_interests, user_popup_notes, 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_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (346, 'bbb', 1182726565, 'cbd44f8b5b48a51f7dab98abcdf45d4e', 'eviesmummy06@googlemail.com', '514f32c8', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, '', '', 0, 1, 1, 0, 1, 1, 0, 'D M d, Y g:i a', 'english', 2, 0, 1, 0, '4db7350a4f74d2')
Line : 676
File : usercp_register.php
I know some of my SQL queries didn't carry, is there any way to tell what needs to be added or is it a matter of going through my mods? |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Simple Colour Usergroups | |
| Posted: 06/24/2007 6:44 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 10:11 PM
Location: St Pete, FL
|
|
|
|
|
|
I know where the images are being found but I don't know what page is actually loading when you enter your domain name in your browser. That is the million dollar question at this point...
The problem is that the query has to have the same number of listed fields as values. The error says that the count doesn't match, so you need to figure out what is extra and remove it from the usercp_register.php file. The query probably isn't at line 676 but it probably isn't that far above the line, so that should give you an idea of where to look...
I'm taking off for the evening, so I will have to take a look at this later. There just aren't enough hours in the day...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Simple Colour Usergroups | |
| Posted: 06/25/2007 1:45 AM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 2:11 AM
|
|
|
|
|
|
Here's the reply from IX...
| Quote:
|
To create a redirect in a Unix-based account, do the following:
* On the control panel home page, click Web Options.
* Select the domain if you have more than one.
* On the Web Service page, scroll down to find the Redirect option and click the Add icon next to it.
* Agree with the charges.
* On the page that appears, create the redirect rule.
Redirect have to be look like :
Redirect from:
http://babydreamz.net/forums/portal.php
To:
http://babydreamz.net/index.html
REdirect have to be from file to the file, it is necessary
|
That's not what we asked is it?  I tried it and just gave me a 'page cannot be displayed'
I asked them again and they replied that they had added an .htaccess file and that it was working, but its not so I replied back to them again explaning that the links aren't going into my forum folder.
I asked on the IM portal site and someone suggested making an index.html file with...
| Code:
|
<html>
<head>
<title>BabyDreamz</title>
<meta http-equiv="Refresh" content="1; URL=http://www.babydreamz.net/forums/portal.php">
</head>
<center><a href="http://www.babydreamz.net/forums/portal.php"><img src="http://babydreamz.net/templates/Diddle/images/logo_phpBB.gif"></a ></center>
<br>
Please wait while BabyDreamz Portal Loads
If you are not automatically redirected, please click <a href="http://www.babydreamz.net/forums/portal.php">here</a>
</body>
</html>
|
but that didn't work either.
Would it work if my forum files were moved into my root?
Its really odd isn't it  |
|
Last edited by Karen on 06/25/2007 12:12 PM; edited 2 times in total |
|
|
|
| Back to Top |
|
|
| Re: [Solved] Simple Colour Usergroups | |
| Posted: 06/25/2007 3:23 AM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 2:11 AM
|
|
|
|
|
|
Re: the error.
I have this at 678 but I have no idea what if anything needs to be removed.
| Code:
|
$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_regip, user_icq, user_website, user_occ, user_from, user_interests, user_popup_notes, 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_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey)
VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . $userdata['session_ip']. "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, '" . str_replace("\'", "''", $postsspp) . "', '" . str_replace("\'", "''", $topicspp) . "', $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";
if ( $board_config['require_activation'] == USER_ACTIVATION_SELF || $board_config['require_activation'] == USER_ACTIVATION_ADMIN || $coppa )
{
|
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Simple Colour Usergroups | |
| Posted: 06/25/2007 4:55 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 10:11 PM
Location: St Pete, FL
|
|
|
|
|
|
The portal redirection problem should be resolved now...
I'm really not sure what the 678 code is in reference to that you posted above. It looks like that belongs to a different topic...
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Simple Colour Usergroups | |
| Posted: 06/25/2007 5:04 PM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 2:11 AM
|
|
|
|
|
|
Yes it is, I posted about it further up 
| Quote:
|
A slightly OT problem - someone just tried to register and got this error 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_regip, user_icq, user_website, user_occ, user_from, user_interests, user_popup_notes, 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_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (346, 'bbb', 1182726565, 'cbd44f8b5b48a51f7dab98abcdf45d4e', 'eviesmummy06@googlemail.com', '514f32c8', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, '', '', 0, 1, 1, 0, 1, 1, 0, 'D M d, Y g:i a', 'english', 2, 0, 1, 0, '4db7350a4f74d2')
Line : 676
File : usercp_register.php
|
Here's what I had at line number 678
| Code:
|
$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_regip, user_icq, user_website, user_occ, user_from, user_interests, user_popup_notes, 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_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey)
VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . $userdata['session_ip']. "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, '" . str_replace("\'", "''", $postsspp) . "', '" . str_replace("\'", "''", $topicspp) . "', $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";
if ( $board_config['require_activation'] == USER_ACTIVATION_SELF || $board_config['require_activation'] == USER_ACTIVATION_ADMIN || $coppa )
{
|
Sorry I've probably confused you 
(Not sure about the portal, I posted back in the other thread) |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Simple Colour Usergroups | |
| Posted: 06/25/2007 11:50 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 10:11 PM
Location: St Pete, FL
|
|
|
|
|
|
The portal and redirects are working fine now. If it isn't for you, try deleting the cache in your browser, then reload the page...
The problem with this query was that there was a field named user_popup_notes that didn't have a VALUES setting. I looked and found that you had added the Personal Notes MOD, which added the user_popup_notes field to the query. However, the corresponding VALUES setting , $popup_notes was not added. So after adding this, I created a new test account and all went smoothly...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Simple Colour Usergroups | |
| Posted: 06/26/2007 1:24 AM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 2:11 AM
|
|
|
|
|
|
I'm still seeing it so will clear them again
As for the user notes that is another query that didn't stay in the database
I've just found my anon forum didn't stay anon too  
Thanks for doing that   |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Simple Colour Usergroups | |
| Posted: 06/26/2007 2:32 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 10:11 PM
Location: St Pete, FL
|
|
|
|
|
|
I'm not having any trouble navigating your forum and portal at all and the redirects seem to be working perfectly...
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
