Failed storing image into the database [Beginner's Corner]

Failed storing image into the database

2005/8/2 10:15
technoboy
Just popping in
Posts: 4
Since: 2005/7/30

Hi please help me. Upload custom avatar is not working, when i upload avatar for my profile it brings me to a blank page. when i try to upload avatar in "misc tool -> Avatar" in the admin menu,
it say
Quote:

Failed storing image 01 into the database.

It was working before but not anymore. my XOOPS 2.2 is a fresh install, if thats any help. what should i do with MySQL to fix this? Thank you in advance for your help

Re: Failed storing image into the database

2005/8/2 10:23
technoboy
Just popping in
Posts: 4
Since: 2005/7/30

i turned on the msql debug mode and it generated these queries

Quote:

INSERT INTO xxx_avatar (avatar_id,avatar_file,avatar_name,avatar_mimetype,avatar_created,avatar_display,avatar_weight,avatar_type) VALUES (0,'savt42ef488a8a5d4.gif','01','image/gif',0,1,0,'S')
Error number: 1146
Error message: Table 'xx.xxx_avatar' doesn't exist
( 0.000844)

i dont know mysql, but i know phpmyadmin basics,
please tell me what to do

Re: Failed storing image into the database

2005/8/3 2:49
technoboy
Just popping in
Posts: 4
Since: 2005/7/30

its fixed, i manually created the table from phpmyadmin. i based the name of the table and all of its sections on what the MySQL debug mode reported. thanks to that tool and the person who invented that!

but i still havent figured out how and why MySQL table "avatar" was deleted in the 1st place. i just hope i wont accidentaly do what i did to cause that problem again.

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Failed storing image into the database

Re: Failed storing image into the database

Re: Failed storing image into the database

Login

Search

Recent Posts

Re: Mymenus Module with XOOPS 2.5.11-Stable

Re: Mymenus Module with XOOPS 2.5.11-Stable

Re: PodTalk Theme (PUBLISHER)

PodTalk Theme (PUBLISHER)

Re: Mymenus Module with XOOPS 2.5.11-Stable

Re: Mymenus Module with XOOPS 2.5.11-Stable

Re: Mymenus Module with XOOPS 2.5.11-Stable

Re: Migrate from Wordpress

Re: Error in https://xoops.org/modules/wggithub/

Re: Error in https://xoops.org/modules/wggithub/

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}