Welcome to Geeklog, Anonymous Saturday, January 11 2025 @ 07:46 pm EST

Geeklog Forums

sql error from bad data in story


Status: offline

pamur

Forum User
Junior
Registered: 11/17/05
Posts: 19
confused
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.
 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? Question
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Please give us some more information. What exactly did you enter? Whatever you type into a story, it should never cause an SQL error.

bye, Dirk
 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"staticpageMadxxxxx"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'
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Which Geeklog version are you on? This sounds like a bug that was fixed in 1.3.11sr2.

bye, Dirk
 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