Sql Issue (i Think)

[ljmyers]

Since the recent server failure and reinstalling everything on my site I have a bug I only just found that I can't seem to get worked out in one of my scripts. I was wondering if anyone here might have any suggestions . . .

When a new poem is submitted and then I confirm so that it will read on the pages, it shows in the "All Categories" category as it should but the database or sql does not appear to read what info is needed to place it in the correct category as well, therefore not being viewable in that particular category it is suppose to be placed via the script. (It is suppose to show in both the "all categories" and the "assigned category") I have to go into the database its self under the specific table which holds the poetry and change the assigned number under category from what is NOW always "0" on the specific poem to the correct number for the specific category that it should be in when the script is suppose to auto do that. It always auto reads "0" when it should read the number assigned for the specific category it was submitted under via the script, therefore leaving it unassigned to a category. Does anyone have any suggestions or ideas as to what or where I can look in the script or the database code to fix this problem?

Link to the page if it helps. The first poem "My Forever" is a sample poem of the problem. It shows in "All Categories" which is the default index page for this link but not in the "Broken Heart" category as it should.
http://www.myonlinemagazine.net/inspirations/index.php

Thanks so much for the help as always and I hope that I did not confuse you.

Sincerely,
Lana

ps - One good thing that came out of that server failure: I learned quite a bit about back-ups and how to reinstall for MySql in phpmyadmin. I originally thought I was really in BIG trouble in that area with my lack of knowledge in sql. :blink:

[dbmasters]

While I refuse to click through to anything as sappy as a "broken heart" category ;) I am wondering if this is a home-brewed app. If so, how do you "approve" content, and set categories, does it not hold the category it was assigned to or does it loose it thru the approval process?

[eugene]

LJ-
Is this still a problem?

[ljmyers]

Yep eugene, it is. I haven't had the time to dig into it yet. I'm open to any suggestions. :unsure:

[eugene]

Do you have a response to Dan's question? If the info gets "lost" in the approval process, then we know where to look to fix it.

[ljmyers]

Dan told me to check the queries.

The answer to his questions are . . .

I approve content by signing into admin.php, clicking on a link taking me to a page holding any submitted poems with options (buttons) to deny or confirm. When I click on confirm it accepts the poem ok but this is where the problem begins. The category for the specific poem which it was submitted under is forwarded to this page leaving me the option to change the category to something different.

As for the category list to the right, on the admin page the tree simply allows you to click on +'s or -'s giving you the option to add/delete a category or sub category.

From what I can tell, the submission holds the category ok but then looses it when I hit the confirm button. While looking at the poem waiting to be confirmed, it shows the category under which it was submitted leaving me to believe it will auto assign to that category. When I confirm the poem it is placed as I said, in the all categories but looses the specific category it was assign to.

Hope this helps eugene. I'm off to the lake for a much needed long weekend of camping so if I don't respond I haven't forgotten about ya. I'll get back with you the first of next week and if you need anymore info just let me know.

Smiles,
Lana

[eugene]

I guess I'd need access to the source code of admin.php.