The vB Geek

The vB Geek (http://www.thevbgeek.com/index.php)
-   Geek Article and Review System (http://www.thevbgeek.com/forumdisplay.php?f=26)
-   -   gars_module_set_details (http://www.thevbgeek.com/showthread.php?t=1411)

Oblivion Knight 05-03-2006 08:56 AM

gars_module_set_details
 
You should consider using an alternative field name than "order", as it causes problems when trying to restore backups - as I found earlier today, and nearly died of a heart attack.. :p

The Geek 05-03-2006 08:58 AM

Nice suggestion. Backups SHOULD encase in ` though so it SHOULD be fine. There are other field names that can potentially cause a conflict like `mod`

Oblivion Knight 05-03-2006 09:03 AM

Mine didn't.. At first I thought I had a corrupt backup. :o

"mod" didn't cause any problems for me, though I'm not saying it couldn't for others.

Richy 05-03-2006 12:08 PM

sort_order?

:)

The Geek 05-03-2006 01:12 PM

I usually use ordnial, I just have to find all instances of where the order column is referenced :(

Actually I guess I can just alias it, then all I have to do is find any occurence of it in a select statement which could be easier.

Thanks again for the heads up.

rjordan 05-05-2006 12:58 PM

lol ... I looked in bug tracker and did not see this listed as a reported bug, so I submitted this last night as well as another one (DEFAULT in GARS_CUSTOM_FIELDS). I tried backing up with cPanel, PHPMyAdmin, and MySQLDUMP at the hell. I ended up getting around it and got my backup restored, but not everyone has hell access like I do. I had to fix it using VI (yes, you read that right!) because none of my Windows editors would save the dump file back right due to line lengths greater than 32768.

If it makes you feel any better, I had to report the same for the ecDownloads modification as well (at vB.org). There, it was DESC used in two spots that caused havoc for me there.


All times are GMT. The time now is 11:36 PM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.