MySQL error reports

[Ronja Rotschopf]

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 ') ORDER BY language DESC LIMIT 2' at line 1\n
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/http/www.cantr.net/www/tags.inc.php on line 382

[BarbaricAvatar]

And since some pages still don't have built in back buttons, it's a real problem.

Could you please tell us which pages don't have back button?

- Containers page,
- lock breaking page,
- chosing project on machine page,
- putting items in container page,
- using items page,
- giving out items page,
- dropping resources page,
- eating page...

[more to come as I discover it]

- Picking up resources page
- Dragging resources page
- Looking at dead body page
- Adjusting boat direction page

I used to use back button a lot, as i have a habit of forgetting what i'm doing and needing to check back every now and again as to where i was. Not to mention being a faster way of getting back to the events page, rather than relying on Cantr loading several pages to get there.
This new system is a real pain in the arse.

[EchoMan]

When editing event_224 in the translation tool:

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 'AND observed=104408 AND type=1 LIMIT 1' at line 1\n

[EchoMan]

Pages without back buttons

Adding two more to the list (at the bottom).

- Containers page,
- lock breaking page,
- chosing project on machine page,
- putting items in container page,
- using items page,
- giving out items page,
- dropping resources page,
- eating page...

- Picking up resources page
- Dragging resources page
- Looking at dead body page
- Adjusting boat direction page

- Create an envelope
- Add resources to project

[Indigo]

Parse error: syntax error, unexpected T_ELSE in /home/http/www.cantr.net/www/objects.inc.php on line 524



I don't know if this error fits in this thread. If not, sorry, but I don't know where I write it then.

[SekoETC]

Sure it fits. Although I'm not seeing an else on that line or anywhere nearby...

[BZR]

Everything is under control, these sql bugs were one time errors

[SekoETC]

If the file was edited, shouldn't it be in subversion too?

[Polt86]

Moderated: Removed some sensitive information. Thanks for reporting though, it has been noted. /EchoMan

I also get many of the "You can't view events of other players" errors both when saying something out loud, but much more frequently when changing the name/description of someone. When changing the name/description, I usually have to try it 3-5 times, usually enough times for the events page to auto-hide everything.

[diurnal_lee]

In Marada, in a cottage called Marada Workshop, trying to use a String Jig gets:

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\n
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/http/www.cantr.net/www/form.amount.use.inc.php on line 48

[SekoETC]

Oh yeah, I got that one too. I just assumed the project had been removed like with coke ovens. But it wouldn't make much sense to devalidate a machine like that.

[Pilot]

String jigs are like anvils so the project button has no use there.

[diurnal_lee]

Argh. *laughs* Thanks, folks.

[Snake_byte]

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 'AND type=1 LIMIT 1' at line 1\n

[AlchemicRaker]

What page did that show up at? (what page should have been there?) Or what were you doing when it showed up?

- Natso