FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Zip file corruption
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Zip file corruption [message #25584 is a reply to message #25335] Tue, 14 June 2005 17:07 Go to previous messageGo to previous message
cstdenis is currently offline  cstdenis   Canada
Messages: 17
Registered: April 2005
Karma:
Junior Member
Quote:

views are database specific feature that MySQL does not support.

I don't see what MySQL's limited SQL support has to do with this. Anyway, mysql 5 supports views.

All it requires is to change the else statement here
        if (__dbtype__ == 'mysql') {
                $c = q("show tables LIKE '".str_replace('_', '\\_', $GLOBALS['DBHOST_TBL_PREFIX'])."%'");
        } else {
                $c = q("SELECT relname FROM pg_class WHERE relkind='r' AND relname LIKE '".str_replace('_', '\\\\_', $GLOBALS['DBHOST_TBL_PREFIX'])."%'");
        }

to
                $c = q("SELECT relname FROM pg_class WHERE (relkind='r' or relkind='v') AND relname LIKE '".str_replace('_', '\\\\_', $GLOBALS['DBHOST_TBL_PREFIX'])."%'");


on line 291 of the upgrade script.

Quote:

Well, you are using a non-standard forum SQL schema, you can't honestly expect the stock upgrade script to be aware of that...

Well, I kind of expected the "Have you manually modified FUDforum's SQL structure?" checkbox to do something.


Anyway, back on topic, any other ideas regarding the header garbage being added to downloads from my forum?

Edit: this is what the extra header data looks like in hex:
1F 8B 08 00 00 00 00 00 00 03 00 2A 80 D5 7F

[Updated on: Tue, 14 June 2005 17:23]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Time Zone
Next Topic: Messages scrambled/Consistency check error
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 01:31:59 GMT 2024

Total time taken to generate the page: 0.04149 seconds