View Single Post
Old
  (#9 (permalink))
MurphDog
Junior Member
 
Status: Offline
Posts: 130
Join Date: Mar 2003
Location: Austin, TX
07-17-2003, 02:26 AM

All the changes above had no effect on the error, it stayed the same.
Even with debugging on, There was no additional error message on the page. Just the usual SQL querry all over the site (specifically by the Site Visitor block, a few modules, and the admin CP's)

I have not installed any addon's except the Site-Visitors block w/ Avatar and a couple minor fixes regarding avatars, webmail, dl/web images, and thats about it.

The modifications to webmail I made were....

Quote:
Howdy Nukers,

I had the same problem as you were having, so I spent some time fingering around with some DB settings. It turns out that the DB may not be fully storing your password. The default value for storing a password is 20 characters. That isn't enough character storage if you have a big password, and not only that, your password gets encrypted, which adds more characters to it. A simple solution it to go into your database with an application such as phpMyAdmin and follow these steps:

- Note: This was performed in v6.5 with phpMyAdmin

1. Scroll down your table list and look for nuke_popsettings, and click browse.

2. Click on structure.

3. Scroll down the field list to passwd and click on change.

4. Edit the Length/Values number and give it a higher number, such as 60. I used 100 since I use real long passwords.

5. Save your changes.

6. Go back into WebMail and go to your account settings and re-enter your password so it gets fully recorded.

I hope that helps you out.
and
Quote:
MurphDog wrote:
k, I did add the @ and that part works great. Thanks!

Whening viewing the contact profile, I'm still getting the warnings for the sql_layer.php file. I noticed this time that it actually doesn't show the profile, the fields are blank. I don't remember if that was the case last night.


in line 246 of the file /modules/webmail/contactbook.php there are a little bug. To fix that,
search for



function view() {
global $userid, $cid, $domain, $imgpath, $bgcolor1, $bgcolor2, $bgcolor3, $prefix, $dbi, $module_name;
OpenTable();
$query = "Select * from ".$prefix."_contactbook where uid='$userid' and contactid='$cid'";
$res = sql_query($query);
if(sql_num_rows($res, $dbi) == 0) {


and replace for:

function view() {
global $userid, $cid, $domain, $imgpath, $bgcolor1, $bgcolor2, $bgcolor3, $prefix, $dbi, $module_name;
OpenTable();
$query = "Select * from ".$prefix."_contactbook where uid='$userid' and contactid='$cid'";
$res = sql_query($query, $dbi);
if(sql_num_rows($res, $dbi) == 0) {

This will remove sql errors as well as allow you to view information on your contacts.
Both from NukeCops

Testing \r\n now.....
 Send a message via ICQ to MurphDog Send a message via Yahoo to MurphDog Send a message via AIM to MurphDog Send a message via MSN to MurphDog  
Reply With Quote