Error on line 1

[Stabil13]

:confused: Listen guys what this error means i can't fix it?
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 '' at line 1

Thanks a lot.

[areidmtm]

We will have to see your code, We can't read minds.

[Basil]

We will have to see your code, We can't read minds.

Speak for yourself.

[felgall]

Well my crystal ball works very intermittently and so it is only about one chance in fifty that I can tell what a particular issue is actually about without the person supplying a link to their page or a copy of their code.

I suspect that most of those are due to the fact that many of the errors i see people asking about are the same ones that many people make.

An SQL syntax error has so many billions of possible causes that even with my crystal ball I can't even tell what type of statement is giving the error.

[areidmtm]

Speak for yourself.

Then read this.....

[Basil]

No I will not make out with you!

[areidmtm]

No I will not make out with you!

Haha, good one!

[Stabil13]

The script that u purchased comes with mod version and has admin panel, so when i'm using admin panel and trying to change the view of the script, like to change head title and after i clicked update buttom to see changes this **** error comes up. Honestly i'm a little bit of newb in php but i check the config.php and admin.php code everything looks fine for me. Then i went to see error logs, but there is no error.php that i could find. mySQL return an error after the script want to update, ok then i decide to go to mySQL official website to see error messeges and how to fix them, u probably know what i'm talking about cause u r experts in this things. So i was trying of about 5 hours to check all messeges in order to find out mine error messege. I got a reall hard time to find this error messege on the web - but none! After all this i thoght to myself, lets give it a try to speak with technical support who sold me the script i open a ticket but no one return my message. Even little help from you guys will help me a lot. Thanks

[areidmtm]

I don't know how we are going to help you with out more information. What is the link, what is the script you're referring to? An error is almost meaningless if we don't have more information.

[Stabil13]

This script is articles manager pro the error comes up from admin panel u guys will not be able to see it. Maybe i should place admin.php source code?
and the link to the main page of the script is the http://theworldweblinks.com/articles/index.php i just installed it so i didn't make any changes yet.

[areidmtm]

This script is articles manager pro the error comes up from admin panel u guys will not be able to see it. Maybe i should place admin.php source code?
and the link to the main page of the script is the http://theworldweblinks.com/articles/index.php i just installed it so i didn't make any changes yet.

Post the source

[areidmtm]

Where did you get that script? It's horribly written! No kidding your getting errors! That one file has over 1200 lines of code?!?!

All that code does not help at all. I think you post some parts at least twice. Use the forums upload function. You'll have to rename the file to a .txt, but use that instead of trying to post all of that in 5+ posts.

[Stabil13]

this is the zip file for the source code for you to download

[Stabil13]

as u can see one line where it saying SITE SETTING i have a problem the rest of it fine

[areidmtm]

Like I said, horribly written. 2372 lines of disorganized cluttered code for one page.

I'd find a new script because just skimming over it, I saw several other errors. There is no way that I'd be able to find the error without testing it.

I also can't help with such little information about the 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 '' at line 1


Means nothing. As you can see, line one does not have any mysql statements. There are several include files that the error might be in there.

First step, find a new script.

[Stabil13]

Well this script cost me 200$ and i'v seen that this script works in the other website. Well anyway thanks a lot man for such a short reply and thanks for tips and advises.

[felgall]

What do you have $prefix set to in the config? Do you have a table created with that name followed by "settings"?

[Stabil13]

That what i have in the config.php $prefix = "articles_"; Do you have a table created with that name followed by "settings"? Answer is YES

[felgall]

Is there anything in the article_settings table or is it currently empty?

[Stabil13]

If you talking about this, i guess it is something take a look i place a picture from PhpmyAdmin

[Stabil13]

dear god after 25 hours of spending sitting behind laptop i finally found something. Listen here it is. I couldn't change the SITE SETTINGS right, and it wouldn't update for new changes and the error comes out. Ok so here what i did - i went to phpMyadmin and change site setting over there where i couldn't change in the script on admin panel, but there actually everything works through phpMyadmin and the sript updated how i needed. So wow i think to myself finally something. But still i can't do that through admin panel in the SITE SETTING. Any Ideas?

[Michael D Price]

Put This At the very begining of admin/admin.php
under <?

foreach($_GET as $k=>$v){
$$k = $v;
}
Now it will work.

In exchange for prodiving you wit ha simple solution to your problem, can you give me the mod rewrite conditions for the seo friendly links for the same script?

this information is in your .htaccess file.

For anyone wondering what the problem was, the sql statement had blank values due to the variables being null.
This problem only existed after php 5. Im assuming it was caused by globals being turned off.

[vidisad]

While importing WordPres mysql database from my old host with php 4.4.1 version to HB with 5.2.5 version i got the same error. You can see the error on this link (http://docs.google.com/Doc?id=dr6c9mh_150hcsvf3fc). Nothing got imported just the error message popped up. help with this would be much appreciated. TIA

[Michael D Price]

Why did that link ask for a cpanel password ....

trying to hack?

[vidisad]

Why did that link ask for a cpanel password ....

trying to hack?No Michael. I just copied it from phpMyadmin to my Google docs and publish it. Why and what would I hach? My own Cpanel?