MySQl error when trying to update a story

ErikV

Posted: 03 July 2008 06:48 AM

[ Ignore ]

Research Assistant

Total Posts: 356

Joined 11-09-2002

When I don’t touch the entry, it’s just fine—it displays fine, etc.
However, I wanted to change something in there, and when I try that, I get this error. Can anyone help me? I do have the Playa plug-in installed. I’m running EE 164, although the counter still says I’m running 1.6.3.

MySQL ERROR:

Error Number: 1064

Description: 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 'XML Capabilities\r[1324] QuarkXPress 8 Interface Screencast\r[1325] The Signific' at line 2

Query: UPDATE exp_weblog_data SET field_id_62 = '[1320] Bezier Tools in QuarkXPress 8 Screencast\r[1321] Drag and drop capabilities of QuarkXPress 8 Screencast\r[1322] Why Font Management is Crucial\r[1323] Layout Design Applications' XML Capabilities\r[1324] QuarkXPress 8 Interface Screencast\r[1325] The Significance of QuarkXPress 8' WHERE entry_id = 1384

Signature

Publisher of IT-Enquirer, a leading resource of information for publishing and creative pros.

Profile

Robin Sowell

Posted: 03 July 2008 07:18 AM

[ Ignore ] [ # 1 ]

Moderator

Total Posts: 23522

Joined 05-20-2002

It’s not escaping one of the ‘s- which is causing a mysql error. Hm- can you do me this. Paste the exact contents from the field where you’ve got ‘[1320] Bezier Tools in QuarkXPress 8 Screencast\r[1321] D…etc’ in a text file, zip and upload. Want to see if I can replicate.

Signature

AKA rob1

Help Request Tips * Pro Network

Profile

ErikV

Posted: 03 July 2008 08:08 AM

[ Ignore ] [ # 2 ]

Research Assistant

Total Posts: 356

Joined 11-09-2002

Hi Robin,

The exact contents of the whole “story” is this : bezier.m4v

It’s used in the template like this:

{if screencast != ""}
        <p><a href="/main/ite/screencast/{entry_id}" target="_blank"><img src="/media/clapper_small.png" alt="screencast"> &nbsp;{title}</a></p>
        {if:else}
        <p><a href="/main/ite/more/{entry_id}">{title}</a></p>
        <p>{sub_head}</p>
{/if} 

But now I’m also having problems with my gallery entries not showing up when I call them with:

{related_entries id="screenshot"}
{if screenshot != ""}
    <p class="center"><a href="{category_path=screenshots/category}" target="_blank"><img src="{thumb_url}" border="0" alt="{title}" title="{title}">
    <br />(Click4Gallery)</a></p>
        {/if}
            {/related_entries} 

Wouldn’t it be Playa after all?

Signature

Publisher of IT-Enquirer, a leading resource of information for publishing and creative pros.

Profile

Robin Sowell

Posted: 03 July 2008 08:20 AM

[ Ignore ] [ # 3 ]

Moderator

Total Posts: 23522

Joined 05-20-2002

If Playa is a plugin, I wouldn’t think so. If it’s an extension- then yes, and it would be my first guess. Still strikes me as odd- if it’s an extension, disable all extensions and see if it makes a difference.

Signature

AKA rob1

Help Request Tips * Pro Network

Profile

ErikV

Posted: 03 July 2008 09:05 AM

[ Ignore ] [ # 4 ]

Research Assistant

Total Posts: 356

Joined 11-09-2002

It IS an extension. I will try what you say and then report back.

Signature

Publisher of IT-Enquirer, a leading resource of information for publishing and creative pros.

Profile

ErikV

Posted: 03 July 2008 09:33 AM

[ Ignore ] [ # 5 ]

Research Assistant

Total Posts: 356

Joined 11-09-2002

OK, it’s Playa all right.

But now I have another problem, and I can’t find where this comes from, and it’s even worse…

This is my HTML head, right now:

<html>
<head>
<style type="text/css">

element {
    background-color: #dbedff;
}

</style>
</head>
</html><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html >

<head>
    <title>Universal Type Server</title> 
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <meta name="author" content="Erik Vlietinck" />
    <meta name="geo.country" content="GB" />
    <meta name="dc.language" content="en" />
    <meta name="description" content="Font Management with Universal Type Server" />
        <meta name="keywords" content="database,designer,font,font management,illustrator,indesign,quarkxpress," />      
    <link rel="stylesheet" type='text/css' media="all" href="http://www.it-enquirer.com/main/S=045bd02e2cc517850b97dd12cdb8722d1e329183/?css=ite/morestylesheet.v.1213992826" />
        <style type='text/css' media='screen'>@import "http://www.it-enquirer.com/main/S=045bd02e2cc517850b97dd12cdb8722d1e329183/?css=ite/morestylesheet.v.1213992826";</style>

</head> 

I don’t even use that CSS at the very top!

Signature

Publisher of IT-Enquirer, a leading resource of information for publishing and creative pros.

Profile

ErikV

Posted: 03 July 2008 09:36 AM

[ Ignore ] [ # 6 ]

Research Assistant

Total Posts: 356

Joined 11-09-2002

OK, found it. I’m making a mess of my page… myself now.

Signature

Publisher of IT-Enquirer, a leading resource of information for publishing and creative pros.

Profile

Robin Sowell

Posted: 03 July 2008 09:59 AM

[ Ignore ] [ # 7 ]

Moderator

Total Posts: 23522

Joined 05-20-2002

0.o I won’t ask. But you need us to poke something, or are you squared away on this one now?

Signature

AKA rob1

Help Request Tips * Pro Network

Profile

ErikV

Posted: 03 July 2008 10:09 AM

[ Ignore ] [ # 8 ]

Research Assistant

Total Posts: 356

Joined 11-09-2002

Thanks, Robin, but I’m in the safe.

The only problem that I am having is the creation of umpteen related entry fields to replace the Playa thing. The idea was good, but the code was crap. I can’t code, but at least I don’t pretend I can

Signature

Publisher of IT-Enquirer, a leading resource of information for publishing and creative pros.

Profile

Ingmar Greil

Posted: 03 July 2008 02:47 PM

[ Ignore ] [ # 9 ]

Moderator

Total Posts: 15368

Joined 05-15-2004

Glad you’re all set, closing this one out.

Signature

Everything will be good in the end. If it’s not good, it’s not the end.

Profile

MSG

‹‹ mysql_real_escape_string() error Category change not being reflected in live site ››

Username		Remember Me?
Password		forgot password?

Post Marker Legend
	New posts	Hot Topic with new posts	New Poll	Moved Topic	Sticky topic
	No new posts	Hot Topic with no new posts	Old Poll	Closed Topic	Announcements

Visitor Statistics
The most visitors ever was 1149, on July 16, 2007 09:33 AM
Total Registered Members:	64915	Total Logged-in Users:	26
Total Topics:	81870	Total Anonymous Users:	18
Total Replies:	440150	Total Guests:	164
Total Posts:	522020