Member Avatar for Secretary

I installed a new script onto a Linux server using cpanel.

ERROR: Nothing parsed, nothing printed
Invalid query
SELECT * FROM dating_country WHERE id IN ()
MySQL 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

As i am a pensioner who is a novice php user, i would rather if someone can explain the "Nothing parsed, nothing printed" error and perhaps how to overcome it, than to hire a programmer and miss the opportunity to learn the solution.
A search on msdn and various forums returns no answers.

Edited by pritaeas because: Moved.
  • 2 Contributors
  • 9 Replies
  • 206 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

The error states MySQL, so you won't find anything on MSDN. The problem in the query is that there are no values in between the parenthesis.

Member Avatar for Secretary

So, my understanding of your answer is that i find a value to insert
SELECT * FROM dating_country WHERE id IN (HERE)

Member Avatar for pritaeas

Correct. If you are using a pre-made script, the values may have to come from somewhere, perhaps it's a configuration issue.

Member Avatar for Secretary

Thank You! pritaeas.
Unfortunately its one of the abandoned (No longer supported) scripts from the Grafx Software Solutions website. Their support ticket system and their Forum has now been removed from their website too. I am really trying to learn a little about PHP/MySQL and messing with their G-Dating Script, as i am now retired,i have enough time for it!

Edited by Secretary
Member Avatar for pritaeas

I am really trying to learn a little about PHP/MySQL and messing with their G-Dating Script

Cool, good luck then. If you have questions, the people here are very helpful.

Member Avatar for Secretary

After spending MANY hours trying to get this script operating properly, i have come to a standstill.
It was possibly ransacked on purpose by the owners/creators before being abandoned.
I had genuinely intended using this script as an addon to a community site if it was working.
The good points of my experience with it is that i have gained a lot of database/script/PHP knowledge.

Member Avatar for pritaeas

Well, one thing to get it going may be to get it up on GitHub or similar website. If you change the code publicly, others may have an interest in helping you fix it.

Member Avatar for Secretary

I had a look at Github, a rather interesting website with lots of knowledge.
But i am unsure if i am allowed to upload this script legally.
It was apparently not open source as it originally required a licence.
Unsure of its legality now since it appears abandoned, and not supported.(Last update 2007)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.