erisande

Is anyone else having trouble? Creating tickets in Help Desk does not send responses to me, so I can not check on the status if issues. it will not email me my Ticket's Key. I have checked my spam filters (on my provider and in my personal email program) and there have been no responses from TCH. This is odd, since TCH is usually really quick in responding, so I believe there is something wrong with my account. [*]I posted a message here a bit ago and it is nowhere to be found (not even in my "last 10 posts" page). Please someone confirm my (near) sanity...

I had something like this happen. My suggestion: Go into: CPANEL > MySQL Databases At the bottom, see "Add users to your databases" Re-add the user to the database. (no need to delete the user and readd, JUST readd.) I do not guarantee this will work, but it made a big difference to me twice. I hope I helped some.

I am hoping for PHP and MySQL 5!!! Woohoo!

I usually check email through Eudora, but it was timing out. So I went in through CPanel and found that I get an error where my mailbox folder listings should be: ERROR: Could not complete request. Query: SUBSCRIBE "INBOX.Trash" Reason Given: SUBSCRIBE failed: Already subscribed to mailbox INBOX.Trash In different email addresses I get different folders with different reasons. Anyone else getting this kind of thing? Like I said, I wanted to ask before I started bugging HelpDesk

After Server 81 was moved, I noticed that one of my databases were gone. It is not extremely important, but I am concerned: If the data in my other databases is from an earlier time, I may have lost some information. The Database that was lost was created over a month ago... A month's worth of data loss is scary! Thanks for any information. Update: After a second look, the data in the remaining tables and databses look good. But I did want to point this out ot other users so they will be sure to check their databases if they are on this server. I am very pleased with TCH's service. I plan on staying for a long time!

I did, and the TCH team was excellent! Unfortunately, it had (I believe) nothing to do with the Collation. I am interested to hear what other people have, though. On my PHPAdmin page, I show I use utf8_general_ci, but when I make a table, it uses latin1_swedish_ci. I am interested to know if this is going to affect any current or future databases. I still do not know about this at all. But for those who have a user scheme on their website and you have used the SQL function of PASSWORD() to create password hashes, I hope I can help you. It was an easy fix: Let me explain (quickly) what my problem was. MySQL 4.0 used short (16 char) password hashing. This is what I used when creating my user records MySQL 4.1 uses long (41 char) password hashing. This is the current scheme of TCH's MySQL. The PASSWORD() function is NOT backwards compatible in the case with TCH. The fix: 1) Lengthen your password field to 41. 2) Change your login script to something like: >function login($username, $password) { // Attempt to log user in with NEW password function // (This will become the new standard) $query = "SELECT * FROM user WHERE username = '$username' and passwd = password('$password') and active = '1'"; $result = $this->QueryTheDB($query); if ( mysql_num_rows($result) > 0 ) { return 1; } else { // Attempt to log user in with OLD password function // (This funtionality will become obselete after all have changed // to new style of password by simply logging in) $query = "SELECT * FROM user WHERE username = '$username' and passwd = old_password('$password') and active = '1'"; $result = $this->QueryTheDB($query); if (mysql_num_rows($result)>0) { // Save the user's password in the new format. $query = "UPDATE user SET passwd = password('$password') WHERE username = '$username'"; $result = $this->QueryTheDB($query); return 1; } } return 0; } Note: "$this->QueryTheDB()" connects to the DB, and returns the mysql_query($query). So what I have done is allow the user to log in no matter which scheme was being used before, and if their pass-hash was the old way, then store the exact password they use back into the DB in the NEW pass-hash format. I hope I have helped someone else out there!

As the first post mentioned, I found that all my tables have "latin1_swedish_c" which doesn't appear to be correct. Now, none of the users can log into my site... And when I use my own tool to change the admin's password, the password even looks different than the others. Other passwords are all lower case and numeric... something like: sj42dweb15vf Any new passwrd I create includes an * first, then all uppercase and numeric information. such as: *DRI43KDLJ4 Please help, I am at a loss!

Hello! I have a file called "functions.php" in the public_html directory and I want to include the file named "secure.php" located in the top most directory of my account. In functions.php I have tried to enter: >include "/secure.php"; But it doesn't seem to work. Also tried: >include "/home/mysite/secure.php"; to no avail. Please help out a brainless geek, please? Thanks! PS: Maybe I don't need to do this. My goal is to make the script to connect to the database secure so no one else can see it. If you have other ideas on this, please let me know!

I've also been a user of Konfab for a while now. I paid about $20, and it was worth every dime! Now (being a free app), it has become even better for everyone! I only wish I had thought of it...

Hello! I hope I can help. I assume you have a database already created... In your CPanel, click MySQL Databases. (The attachment shows the lower part of the screen displayed.) In the Users section, enter a username and password, then click Add User. When the processing ends, go back to the same screen and select the User and DB from the drop down list (as shown at the top of this attachment), give all privs. For now, all privs is ok for testing, but you may want to change things later on. Then your SQL code on your page should be something like: >$connection = mysql_pconnect("localhost","USERNAME","PASSWORD") or die ("Couldn't connect to server."); $db = mysql_select_db("DATABASE_NAME", $connection) or die("Couldn't select database."); Ok, note: USERNAME must match the username exactly as it appeared in the drop down lists. It will look something like: [account]_[usernameyouentered] as will the DATABASE_NAME: [account]_[databasename] So for example: USERNAME = myweb_cooluser DATABASE_NAME = myweb_niftydb I hope this helps some.

I appriciate TCH and the users for keeping me up to date on things!

Is it possible to run applications on TCH created with OpenLaszlo? If not at this time, is there any notes on the agenda to allow such a thing? Thanks!

Update: It was my DSL modem. Once I changed it, things worked ok. I still have one problem: if I try to transfer a file using ICQ, it reboots the modem, but I have read somewhere how to fix that. I just have to find that info again. Thanks for your thoughts and ideas!

Thanks!

1. http://www.insideleg.com 2. Inside Leg 3. Giving theatres the ability to view, add, and edit actor measurements. 4. Commercial 5. Link back to TCH is available on all pages of the site.

Unfortunately I am. That is what got me all excited earlier in the year. I was hoping this new patch would work. I have uninstalled/reinstalled a few times as well. But I have had no luck. Thanks everyone for helping. I will keep my eye on the board in case someone figures it out. Until then, I will be chatting in other ways. Sigh.

Looking into it, thanks!

Validated a little bit ago, and loving the TCH peeps!

Disc (Frisbee) Golf, Reading, Web design, and eating. Mmmm, sweet sweet food....

I think I have it with AIM as well. It has been a while since I could message people without problems, and i9t happened as soon as I got DSL. Now that you mention that, I notice that AIM/ICQ are of the same plugin type. When Trillian loads, it shows them together. And if I turn off DSL and use a dialup connection, I can use Trillian (ICQ) with no problems... That is what has been bugging me all this time. *Keeping my fingers crossed*

3.1 bld 121 I just tested this again. Within 12 seconds after sending a message, my DSL modem reboots! And the person I sent the message to never gets the message. (He replied back through email telling me he did not get the ICQ message. Again, thanks for responses. I will keep an eye on this topic.

Sorry... Trillian 3.1 build 121 Also, the most current ICQ (4) and the previous version. Any use of ICQ causes my DSL modem to reboot. Such an oddity.

Thanks for the quick response! I will look into it and see how to upgrade.

Trillian and dropped DSL connection... I know it is not really part of this conversation, but I was hoping to get a Trillian user to read it. When I send/receive mesages, I sometimes get kicked off within 10 seconds ofthe send/receive. After rebooting the modem, I can usually keep the connection going and chat with no problems. With ICQ I ALWAYS lose the connection no matter what I use to send message (Trillian or ICQ's own program). Any ideas? Thanks!

Should we manually upgrade to this new version, or is TCH going to spooprt the upgrade through the control panel?