Previous Thread
Next Thread
Print Thread
Hop To
#20916 12/23/2000 2:43 PM
Anonymous
Unregistered
Anonymous
Unregistered
I have installed the PHP evaluation version here:
http://www.grassy.com/boards/wwwthreads.php?Cat=
I did not get any errors during the install and everything progressed nicely until I tried to post a test message. It says that it was posted but it never appears in the index. Any ideas where I went wrong or where to check? Thanks for any help you can provide.

#20917 12/23/2000 5:15 PM
Anonymous
Unregistered
Anonymous
Unregistered
I don't know the answer to that....but seems your stylesheets fail to load...you may want to check the path....

#20918 12/23/2000 5:28 PM
Anonymous
Unregistered
Anonymous
Unregistered
I had the path rather than the URL in that variable. Thanks for the head's up. I've been working on this thing all day and am brain fried:-)
Still no luck on posting, when I try to view the post after posting and before it automatically redirects me I get the message:
"We encountered a problem. The reason reported was:
There was a problem looking up the post in our database."
Ring a bell?

#20919 12/23/2000 6:31 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Do you have full moderation turned on for your boards? You might want to try looking at the database itself and see if anything is actually getting added to this table. If you have phpMyAdmin installed then you'd want to look at the w3t_Posts table. If not then you'll need to do it via command line like:
mysqldump databasename w3t_Posts > filename
And then take a look at filename and see if any of the posts are actually in the db.
I registered a username on your site so it looks like everything else is working ok.

-------------------

Scream

WWWThreads Developer

#20920 12/23/2000 7:18 PM
Anonymous
Unregistered
Anonymous
Unregistered
I have moderation turned off so posts should show up right away. Unfortunately I am new to MySql so I am not sure how to check if the database is being populated:-)

#20921 12/23/2000 7:39 PM
Anonymous
Unregistered
Anonymous
Unregistered
I noticed that when I select "Forum information" it says:
You have read only privileges for this forum.
Could this be why I cannot post? If so where do I change this? What variables should be selected in the "Change Board's write groups" section? Every time I change something there it says that it did it butif I go back in it displays what was there before my changes?
Also when I login it does tell me that I have 8 total posts but we can't see them:-)

#20922 12/23/2000 8:02 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
There is a slight bug in the forum information screen that says Read Only even if you do have write privs.
Do you have telnet access to your domain? If so, then you can use mysql fairly easily by just using the mysql command prompt.
If you use the mysqldump command I wrote in the earlier reply then this will dump your posts table to a file so you can see if the posts are actually being entered into the db.

-------------------

Scream

WWWThreads Developer

#20923 12/23/2000 8:35 PM
Anonymous
Unregistered
Anonymous
Unregistered
Yes, I do and did try it and got the following error:
ERROR 1064: You have an error in your SQL syntax near 'mysqldump THEDATABASENAME w3t_Posts > filename' at line 1
Is this incorrect?

#20924 12/24/2000 1:58 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
It looks like you ran this from within mysql itself. The mysqldump command is just a command that you run from the telnet prompt.

-------------------

Scream

WWWThreads Developer

#20925 12/24/2000 1:59 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
And since you do have PHP installed, you might want to install phpMyAdmin. This is an invaluable tool for working with databases. Works great for situations such as this.

-------------------

Scream

WWWThreads Developer

#20926 12/24/2000 10:02 AM
Anonymous
Unregistered
Anonymous
Unregistered
Here is the error message I get when typing your commands:
mysqldump: Got error: 1044: Access denied for user: '@localhost' to database 'THEDATABASENAME' when selecting the database
Does this mean anything to you?

#20927 12/24/2000 10:27 AM
Anonymous
Unregistered
Anonymous
Unregistered
You are right, this is nice. I am able to see the following tables:
w3t_AddressBook 0 records

w3t_Banned 0 records

w3t_Boards 2 records

w3t_Category 3 records

w3t_Groups 12 records

w3t_Last 6 records

w3t_Messages 8 records

w3t_Moderators 2 records

w3t_Online 4 records

w3t_PollData 0 records

w3t_Polls 0 records

w3t_Posts 14 records

w3t_Subscribe 0 records

w3t_Users 7 records
When I browse or select them the data is in there. Why is it not visible on the message board?

#20928 12/24/2000 3:02 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
I know with phpMyAdmin you can dump out data from a specific table to a file. In order to figure out what is going on, I need you to dump the data from the w3t_Posts table and email it to me. There has to be a field in there that isn't getting updated properly.

-------------------

Scream

WWWThreads Developer

#20929 12/24/2000 5:45 PM
Anonymous
Unregistered
Anonymous
Unregistered
Just respond to the email and let me know what you think. Thanks!


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
1 members (Geoff), 1,018 guests, and 215 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)