Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
Fatal MSQL error
What does this error mean?
Fatal error: 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 ‘jpg limit 1’ at line 1 select ID,Section from `textpattern` where ID = 52.jpg limit 1 in /home/.debonhair/runjeeta/runjeeta.com/textpattern/lib/txplib_db.php on line 61
and why am I getting it on this page: http://www.runjeeta.com/webdesign/9/rhizomes ?
I’ve tried making a form and putting the form on a special page and this and that and I don’t know how to fix it.
please help!
“Words have no wings but they can fly a thousand miles.” (Korean Proverb)
Offline
#2 2006-12-14 07:11:26
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Fatal MSQL error
Looks like you solved the problem yourself. Best guess is you had entered something incorrectly somewhere.
Offline
Re: Fatal MSQL error
No, sadly I didn’t , see I want to add this
<a href=”/images/52.jpg” target=”_blank”>Screenshot 1</a><br/> <a href=”/images/53.jpg” target=”_blank”>Screenshot 2</a><br/> <a href=”/images/54.jpg” taget=”_blank”> Screenshot 3</a>To this page: http://www.runjeeta.com/webdesign/9/rhizomes and it won’t let me. When I click on those links, that’s when I get the Mysql error.
Sorry, I was playing around with the page more, that’s why it appeared ok.
Last edited by raspberryheaven (2006-12-14 07:16:06)
“Words have no wings but they can fly a thousand miles.” (Korean Proverb)
Offline
#4 2006-12-14 07:33:47
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Fatal MSQL error
You’ve got a section named “images”, and a real directory named “images” to hold your images. One of them has to change it’s name.
If you want to keep the section, you need to:
- use FTP and rename the folder named “images” to something else
- go to your “Advanced” admin prefs and change the appropriate setting (it’s one of those near the top of the page)
Otherwise rename your section. :)
Offline
Re: Fatal MSQL error
I’m peachy with deleting the section named images, but where do I find it? I went to “sections’ in my admin tab and can’t find it.
raspberryheaven
“Words have no wings but they can fly a thousand miles.” (Korean Proverb)
Offline
Re: Fatal MSQL error
Do you mean txp_img? I found that in my directory inside my textpattern folder. Oh but, I did do as you said, and changed the image folder name in ftp and in my admin area just until i can figure out where my image section is.
Also, whilst none of my other image pages are effect badly, my webpage: http://www.runjeeta.com/webdesign/9/rhizomes is still churing out the links wrong. Am i not supposed to have links to images in the body of my articles?
Becky
Last edited by raspberryheaven (2006-12-14 08:07:27)
“Words have no wings but they can fly a thousand miles.” (Korean Proverb)
Offline
#7 2006-12-14 10:50:49
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Fatal MSQL error
Do you mean txp_img? I found that in my directory inside my textpattern folder.
No. Forget about that for now.
Am i not supposed to have links to images in the body of my articles?
You most certainly can.
Don’t work:
http://www.runjeeta.com/imagesx/52.jpg
http://www.runjeeta.com/imagesx/53.jpg
http://www.runjeeta.com/imagesx/54.jpg
Works:
http://www.runjeeta.com/imagesx/52.png
http://www.runjeeta.com/imagesx/53.png
http://www.runjeeta.com/imagesx/54.png
You’re actually entering incorrect urls to your images. How are you creating those links? By hand? A tag?
Now, for the fact that those urls are behaving strangely (trying to load up a section that doesn’t exist), can you post your diagnostics results?
Offline
Re: Fatal MSQL error
Oh that’s nuts! I never realized they were .pngs. :P I’ll post in one second as soon as I fix my error. I was coding by hand though. Sorry!.
UPDATE: It works. Changing it to .png worked. Lame-o error on my part, but thank you for the help.
I have my site on debugging mode right now and everything looks ok. I don’t know why it would load up a section that doesn’t exist. Here is what my diagnostic panel says:
Textpattern version: 4.0.3 (r1188)
last_update: 2006-05-19 18:27:57/2006-05-19 18:14:42
Document root: /home/runjeeta/runjeeta.com (/home/.debonhair/runjeeta/runjeeta.com)
$path_to_site: /home/.debonhair/runjeeta/runjeeta.com
Textpattern path: /home/.debonhair/runjeeta/runjeeta.com/textpattern
Permanent link mode: section_id_title
Temp folder: /home/.debonhair/runjeeta/runjeeta.com/textpattern/tmp
Site URL: www.runjeeta.com
PHP version: 4.4.4
Register globals: 1
server_time: 2006-12-14 11:26:49
MySQL: 4.1.14-Debian_5-log
Locale: en_US.UTF-8
Server: Apache/1.3.37 (Unix) mod_throttle/3.1.2 DAV/1.0.3 mod_fastcgi/2.4.2 mod_gzip/1.3.26.1a PHP/4.4.4 mod_ssl/2.8.22 OpenSSL/0.9.7e
php_sapi_mode: cgi
os_version: Linux 2.4.32-grsec+f6b+gr217+nfs+a32+fuse23+tg+++p4+c8+gr2b-v6.194
.htaccess file contents:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#RewriteBase /relative/web/path/
<IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]
RewriteRule ^(.*) index.php </IfModule>#php_value register_globals 0
————————————
Let me know if this is the wrong info.
raspberryheaven
“Words have no wings but they can fly a thousand miles.” (Korean Proverb)
Offline
#9 2006-12-15 14:31:12
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Fatal MSQL error
You’re using 4.0.3 so it doesn’t provide any clean url testing in the diagnostics. I don’t see anything out of place, so I am guessing that your server doesn’t quite understand the mod_rewrite rules Textpattern uses (it understands them enough so that they work, but not enough to not do strange things when it involves real directories). I’m not certain how the rules could be adjusted for you, but at least when/if you have a similar problem again, you’ll know what to check for.
Offline
Re: Fatal MSQL error
hmmm how myserious. I’ll upgrade soon and see if I still have the same problem. Also, do you think this is something that must be manually deleted from my database? Like, say I deleted the section” images” but the entry still remained in the database?
“Words have no wings but they can fly a thousand miles.” (Korean Proverb)
Offline
#11 2006-12-16 17:27:05
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Fatal MSQL error
No.
Offline
Pages: 1