VJ Central calendar post issue - Warning: mysql_fetch_assoc(): supplied argument ...

[jeremy]

:help: how to solve this ? :help:

When trying to add an event in the VJCentral calendar,
i can login, i can complete the form, i also receive a message that the event has been ad.... but i get this:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/includes/classes/topic.php on line 51

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/includes/classes/topic.php on line 80

Consequence: no event in the calendar.

I try on diffents PC, all XP, using IE or other browsers, same error.

who can help me with this ?

Jeremy

:help:

[Rovastar]

What are you typing into to the calender submit box.

Some of VJC dialog boxes are a bit picky.

[jeremy]

i try a lot of different combination, still same errors
I also try with only 1 letter in the fields, same errors
any ideas ?
I'm the only one ?

[jeremy]

hum...
-> i try on different PC , different OS, different browser, different IP range, diffent language, time zone, keyboard config...
** Still same issue **

-> i try with different information in the fields
** still same issue **

-> I also try to create an event with the same info than an existing event in the calendar... I have the same "MySql" error message...

Looks like a issue with the data of my account in the db...

[karl]

don't think this got anything to do with your client, this seems like a classic corrupted mysql database. If you are the only one with this problem i guess there is data in your profile that freaks out the database.

[elbows]

I have not looked at this problem, but a complete guess off the top of my head is whether it could have anything to do with the ' in your user title (ie VJ's )

[karl]

oh, somebody forgot to escape the SQL, i think your right

[jeremy]

Solution found

a big thank you to elbows:

the ' in my user title (ie VJ's )

was the cause of the issue.
i remove it, no more problem.


thanks thanks thanks.
:yep: