Register forum user name Search FAQ

Gammon Forum

Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the password reset link.

Due to spam on this forum, all posts now need moderator approval.

 Entire forum ➜ Forum software ➜ Installation ➜ Table Not Specified
Table Not Specified

It is now over 60 days since the last post. This thread is closed.     Refresh page

Pages: 1 2  3  4  

Posted by Kris   USA  (198 posts)  Bio
Date Sat 04 Jan 2003 09:42 PM (UTC)
Message
I got so close! I'm trying to install your forum code on my server, and have run into a brick wall. Although running under WinXP, my apache has PHP installed, and MYSQL is installed and functional as well.

I got as far as Section E of your INSTALL file: log on as administrator. I successfully logged on as administrator (after figuring out that the user/pass you listed there were literal), and then the install file said to change the admin password.

So I selected 'user' in the Edit Table dropdown field, and clicked the Edit button. Here's the page that came up:


We apologise that there has been a problem with the web server ...
Table name not specified

Error occurred at 2003-01-04 14:34:08

Please notify kris@aethia.org of the above message and time.


Unfortunately, that kris@aethia.org guy was no help at all :P I then experimented with different selections in the dropdown menu; all yielding the same error.

There was no mention of the problem in the INSTALL file, nor could I find any post about it, so here I am =) What would be causing that, and how would I go about fixing it?
Top
Posted by Nick Gammon   Australia  (23,162 posts)  Bio   Forum Administrator
Date Reply #1 on Sun 05 Jan 2003 09:51 PM (UTC)
Message
Since that was released PHP has changed the default way it processes variables passed to scripts. It sounds like the table name which should be passed down to the script is not there.

Try this. Edit the file common.php, and at the very end, add this line:

import_request_variables ("GPC");

- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #2 on Sun 05 Jan 2003 09:59 PM (UTC)
Message
Awesome, that worked! I'll make a post if/when I get it working, including a few tips on getting it to work under Windows. :)
Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #3 on Sun 05 Jan 2003 10:01 PM (UTC)
Message
Oops another problem!! When I clicked 'change'....

There is a problem ...
Primary key [id] is invalid [Field must be numeric]. You entered 'head'


Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #4 on Sun 05 Jan 2003 10:05 PM (UTC)
Message
By the way, that occured when trying to change home_url. I didn't try it for any of the others yet.
Top
Posted by Nick Gammon   Australia  (23,162 posts)  Bio   Forum Administrator
Date Reply #5 on Tue 07 Jan 2003 09:05 PM (UTC)
Message
What table had you selected when that happened?
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #6 on Wed 08 Jan 2003 01:30 AM (UTC)
Message
I tried it with several different selections. It seems that I'm getting the error for all of them; not just home_url.
Top
Posted by Nick Gammon   Australia  (23,162 posts)  Bio   Forum Administrator
Date Reply #7 on Wed 08 Jan 2003 04:30 AM (UTC)
Message
You have to choose a table, which one did you choose? The control table should allow alpha keys, most others have numeric keys.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #8 on Thu 09 Jan 2003 04:32 AM (UTC)
Message
Ok here's an example. I followed the instructions in INSTALL to the letter, as follows:

2. CHANGE the administrator password now!

a. Select "Edit table" : "user", then click on "Edit" button.
b. Click on "List All" button.
c. Click on "Administrator [1]".
d. Change the username from "Administrator" to your name (if you want).
e. Change the password by putting an "=" in front of it, eg.
Password: =swordfish
The password is hashed, when you visit the page again you will see it hashed.
f. Click on the "Change" button near the bottom of the page.


I did everything, changed username to "Kris", and changed the password to "swordfish" (just as a test; don't worry not my actual pwd hehe). I did not modify any other fields. I then clicked on the "change" button as instucted. Here's the page that came up:

There is a problem ...
Primary key [userid] is invalid [Field must be numeric]. You entered 'tail'


Page execution time: 0.013 seconds


Comments to: webmaster@your_site.com


None of the fields had 'tail' in them. I checked and re-checked every single step; I followed the instructions precisely.

The 'userid' key, as you know, is not one of the fields; it showed up as '1' on the form, and I couldn't change it if I wanted to. How should I fix this increasingly baffling problem?
Top
Posted by Nick Gammon   Australia  (23,162 posts)  Bio   Forum Administrator
Date Reply #9 on Thu 09 Jan 2003 08:04 PM (UTC)
Message
Ah, the light begins to dawn. :)

There is (was) a problem with editing the user table, which you are trying to do, because some of the fields clash with the userid which is established when you log on.

I can't reproduce that now, so maybe I fixed it. I'll zip up a version with my latest php files in it, and upload that, once I work out what they are. Give me a couple of hours, and I'll see what I can do.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Nick Gammon   Australia  (23,162 posts)  Bio   Forum Administrator
Date Reply #10 on Thu 09 Jan 2003 10:09 PM (UTC)
Message
I think I have all the changes incorporated now. If you download the file below you should get a copy of the forum, including table editor, just as it works for me right now.


ftp://ftp.gammon.com.au/forum/forum_1.1.tgz
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #11 on Sun 12 Jan 2003 04:07 AM (UTC)
Message
I just tried it with the new forum script, and at the same point as before, I received the same error message when trying to change the administrator password and name:

There is a problem ...
Primary key [userid] is invalid [Field must be numeric]. You entered 'tail'


Page execution time: 0.018 seconds


I haven't a clue where to even begin to debug something like this hehe.
Top
Posted by Nick Gammon   Australia  (23,162 posts)  Bio   Forum Administrator
Date Reply #12 on Sun 12 Jan 2003 10:42 PM (UTC)
Message
Sounds like your version of PHP works a bit differently t o mine. Can you tell me what version it is? Is it on Windows? If you aren't sure, try making a small file like this:

<html>
<head>
<title>PHP info</title>
</head>
<body>
<?php
phpinfo();
?>
</body>
</html>


Save it as info.php, and execute it from your web browser.




- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Nick Gammon   Australia  (23,162 posts)  Bio   Forum Administrator
Date Reply #13 on Sun 12 Jan 2003 10:43 PM (UTC)
Message
Also, do you only get that error editing the user table? What happens if you try to add/change a record in the control table?
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Kris   USA  (198 posts)  Bio
Date Reply #14 on Sun 12 Jan 2003 11:27 PM (UTC)
Message
Here's my version of php: PHP Version 4.2.1

My apache webserver and mysql server are running under Windows XP Pro. Here's the version of Apache: Apache/1.3.20 (Win32) PHP/4.2.1

The error occurs when trying to edit other tables as well, however, the "you entered 'blah'" part is slightly different. For example, when trying to edit faq_url in the control table (didn't modify it; just accessed it and clicked the 'change' button):

There is a problem ...
Primary key [id] is invalid [Field must be numeric]. You entered 'head'


Page execution time: 0.004 seconds


In this instance, it was 'head', whereas when trying to change the administrator name/password it was 'tail'.
Top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.

163,553 views.

This is page 1, subject is 4 pages long: 1 2  3  4  [Next page]

It is now over 60 days since the last post. This thread is closed.     Refresh page

Go to topic:           Search the forum

[Go to top] top

Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.

Home