Loading...
 
Skip to main content

Features / Usability


Upload Problems

posts: 96 United States

I'm having trouble when uploading files. Not all files, just some. I get the error message below. The error refers to a line in another page, but I don't know PHP well enough to be able to see the relevance here. Any ideas on what the fix might be?

Thanks for any help.

bzahn

___
Warning: MYSQL error: DB Error: unknown error in query:
insert into tiki_files(galleryId,name,description,filename,filesize,filetype,data,user,created,downloads,path,hash) values(10,'Der SchnappiPlayer','','schnappi_player.exe',1931529,'application/x-msdownload','MZP\0\0\0\0\0\0??\0\0?\0\0\0\0\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0? ?!?L?!??This program must be run under Win32 $7\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0PE\0\0L\0^B*\0\0\0\0\0\0\0\0?\0?? \0P \0\0?\0\0\0?\0?A\'\0\0\0\0\0P\'\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\'\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 ?\'\0T\0\0\0P\'\0 q\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ in x:\mypath\lib\tikilib.php on line 101


Lines 98-102 of tikilib.php read as follows:

98 // Reports SQL error from PEAR::db object.
99 function sql_error($query, $result)
100 {
101 trigger_error("MYSQL error: ".$result->getMessage()." in query:<br/>".$query."<br/>",E_USER_WARNING);
die;
102 }


posts: 32 United States
perhaps you could change so files are stored on the server rather than in the database?
posts: 96 United States

Thanks. I suppose I could, but I have a lot in the database already. To make such a change, I imagine I would have to download everything and re-upload it again. That would be quite an undertaking.

At this point, I'd rather try to solve the current problem if possible.

I'm still open to suggestions for how to fix this problem.

Thanks!