Description: Allows users to store more information (Address, City, Zip Code, Phone number, Country etc) making the threads act like a contact management system
Step 5.5 of the instructions for this mod shows a change that has to be made to the changebasic.php file, however the line(s) that the instructions say to change do not seem to be in that file...
Also, the changebasic.php is not listed as one of the files that get modified...
Have the installation instructions been properly updated for 6.2?
Yes it does. Actually there are some differences between 6.2 and 6.3 which I will change very soon in the instructions. At the moment the instructions work for 6.3
Just to let everyone know I have updated the modification. There was a subsection in the instructions that was missing - editbasic.tmpl - and some typos. For some reason I picked up the wrong file to upload
I ran into a problem installing this hack to a 6.3 board. When my hacked editbasic.php is uploaded I get the following error while trying to edit my profile through my home:
Code
SQL ERROR: Unable to do_query: SELECT U_LoginName,U_Password,U_Email,U_Fakeemail,U_Name,U_Signature,U_Homepage,U_Occupation,U_Hobbies,U_Location,U_Bio,U_TextCols,U_TextRows,U_Extra1,U_Extra2,U_Extra3,U_Extra4,U_Extra5,U_Picture,U_Visible,U_AcceptPriv,U_OnlineFormat,U_PicHeight,U_PicWidth,U_Sex,U_Address,U_City,U_ZipCode,U_Country_Location,U_Country_Origin,U_Phone,U_Mobile,U_ShowAddress,U_ShowPhone FROM w3t_Users WHERE U_Number = '4'<br />Unknown column 'U_ShowAddress' in 'field list'<br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wwwtsbiu/public_html/iBASE/mysql.inc.php on line 131
It also says "We could not find your profile 'Iceman':
If I upload a clean copy, it doen't give me the errors. The fields are there, but changes don't stick.
Slayer, the database query was missing two fields. You need to run this:
ALTER TABLE w3t_users ADD U_ShowAddress CHAR( 3 ) DEFAULT 'no' NOT NULL, ADD U_ShowPhone CHAR( 3 ) DEFAULT 'no' NOT NULL;
to complete your installation. These two fields allow the address and phone information to be shown or not to all users (admins are not affected by this).
Thanks dimopoulos. That query corrected the sql problem I was having. Now I have another problem. I can put my info in the fields but not all of the fields display thier contents in the user profile. Both of the contry indicators work, but the address, phone, city, and zip code fields are all blank. I have selected yes to display my address and phone info. When I go back into edit, the fields are still holding my info and displaying it there. I don't know what it could be.
Josh, I don't see the Contact Management system implemented in your site. It just had the standard fields to edit.
I made the changes. Now has the following error: ----- Warning: error_log(/home/wwwtsbiu/public_html/iBASE/backups/20030714_mysql.log) [function.error-log]: failed to create stream: Permission denied in /home/wwwtsbiu/public_html/iBASE/mysql.inc.php on line 205 SQL ERROR: Mon, Jul 14 2003 20:29:54 -0400 Database error only visible to forum administrators
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wwwtsbiu/public_html/iBASE/mysql.inc.php on line 131 ---- Then below the header it says: We cannot proceed. This user is no longer in our database.
Okay, I'm a little slow. I just figured out how to view the MySQL error logs. I had left this to the wayside while I tackled other things. I've now got my 6.3.1 test board installed. I am attempting to get this installed. I am close enough to almost taste it. I am getting the same error as above when trying to view profile. In the error log it says U_BirthMonth does not exist. If I pull it and the other U_Birth* out the country fields come out of the profile and data get put in the wrong place.
I had a look at it slayer and it brings up errors whenever you try to view a user. Can you please create an admin account and PM me with the info? I need to have a look at your DB.
I've attatched a new copy of the instructions. I pulled an errant character out of the sql query, corrected a place in generic.php where it was calling the wrong varible, fixed some typos, and changed up some places to make it easier to search for the lines of code you are replacing.
I didn't make any changes to account for the birthday hack though. Not sure what the sql commands would be.
Not on my end. With the holidays, travelling, and lack of enough hours in a day... I'm only getting a couple things done each night on my upgrade to 6.4.
Once my 6.4 is upgraded and hacked, I'm tackling this first thing. Probably 2nd week of the new year. I'll be spending this coming weekend trying to finish my upgrade.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.