search

dustin-lennon / Nova-Personal-Log-Change

Adds Stardate and Location to the personal log posts
1 stars 0 forks source link

SQL Syntax Error When Viewing Saved Personal Logs #2

Closed jerichocain closed 9 years ago

jerichocain commented 12 years ago

Good Day,

I am receiving the following SQL syntax error on all sites when I go in to view a Saved Personal Log (or, as we call them, Narrative Post). I believe it is related to the Mod that puts the "stardate" on personal logs, but I'm not sure.

Does not occur when viewing activated logs or viewing saved logs via the edit option.

The error is:

A Database Error Occurred Error Number: 1064

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 log_date asc LIMIT 1' at line 5

SELECT log_id FROM (nova_personallogs) WHERE log_status = 'activated' AND log_date > ORDER BY log_date asc LIMIT 1

Thanks and Regards,

Jer

dustin-lennon commented 12 years ago

I'll take a look into this. I apologize for taking so long to see this. Have been busy with school the past few months.

dustin-lennon commented 12 years ago

I have tried to duplicate this error and haven't been able to under Nova 2.0.1. If you haven't already done so, update to Nova 2.0.1 and let me know if you still get this error.

jerichocain commented 12 years ago

Thank you for trying! I haven't yet upgraded my active games and not sure when I will since they have so many language changes. I'm really dreading redoing all that and I'm skinning challenged on a good day sooooo.......

Thanks again!

Alisa (Jericho on the Anodyne Forums)

On Wed, Feb 8, 2012 at 5:24 PM, Dustin < reply@reply.github.com

wrote:

I have tried to duplicate this error and haven't been able to under Nova 2.0.1. If you haven't already done so, update to Nova 2.0.1 and let me know if you still get this error.

Reply to this email directly or view it on GitHub:

https://github.com/demonicpagan/Nova-Personal-Log-Change/issues/2#issuecomment-3877665

dustin-lennon commented 12 years ago

It's my pleasure to assist where I can. I'll keep this open for some time before closing it so I know it may potentially still be out there.

dustin-lennon commented 9 years ago

Closing this issue as it has been a little over 2 years since anything was mentioned about this.