Welcome to Geeklog, Anonymous Saturday, January 11 2025 @ 07:46 pm EST
Geeklog Forums
sql error from bad data in story
I put something unacceptable in one of the stories when I was editing it. Now I get a sql error and since it trys to display it on the homepage, nothing works. I get the same error when I try to edit the story so I am screwed. What can I do? I just got it up and running last week and when I tried to back up it said I didn't have permission in the backup directory so I had put it off. Is there a way to remove a story without being inside the program? BTW I was trying to use the static pages html tag when I screwed it up. How exactly is that tag used and how in the world can the database get fubared if you goof that up? That seems like something that would happen all the time.
6
6
Quote
Status: offline
pamur
Forum User
Junior
Registered: 11/17/05
Posts: 19
I got the site back up by removing the story from the database using the MySql adminstration tool. But the question still remains. How do you use the internal link HTML commands for staticpage, story, etc? I tried something and blew the site off the air. Anybody that could publish could do that, couldn't they?
6
5
Quote
pamur
Anonymous
Thanks for the reply. Dirk
Yes. That was what I thought too. I was trying to guess what I needed so I put in "bracket"staticpagexxxxx"bracket in the middle of the text. Where xxxxx was the static page Id that was assigned to it. I didn't include the text part. I did try to find instructions for their use but I didn't know they were called autolinks. I assumed it wouldn't hurt to try.
This is the error in the error log.
Sun Nov 27 15:00:03 2005 - 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE sp_id = '20051126115030200'' at line 1. SQL in question: SELECT sp_title FROM WHERE sp_id = '20051126115030200'
Yes. That was what I thought too. I was trying to guess what I needed so I put in "bracket"staticpagexxxxx"bracket in the middle of the text. Where xxxxx was the static page Id that was assigned to it. I didn't include the text part. I did try to find instructions for their use but I didn't know they were called autolinks. I assumed it wouldn't hurt to try.
This is the error in the error log.
Sun Nov 27 15:00:03 2005 - 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE sp_id = '20051126115030200'' at line 1. SQL in question: SELECT sp_title FROM WHERE sp_id = '20051126115030200'
5
5
Quote
All times are EST. The time is now 07:46 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content