Avatar / Profile Pic Max Filesize Limited to 65536 bytes

[Kier]

Run the following query to allow larger avatars and profile pictures on your board:

ALTER TABLE usergroup
CHANGE avatarmaxsize avatarmaxsize INT UNSIGNED NOT NULL,
CHANGE profilepicmaxsize profilepicmaxsize INT UNSIGNED NOT NULL

[a43079]

Run the following query to allow larger avatars and profile pictures on your board:
ALTER TABLE usergroup
CHANGE avatarmaxsize avatarmaxsize INT UNSIGNED NOT NULL,
CHANGE profilepicmaxsize profilepicmaxsize INT UNSIGNED NOT NULL

i rand the query and i got this any ideah?

Database ero running on localhost

Error
SQL-query : ALTER TABLE usergroupCHANGE avatarmaxsize avatarmaxsize INT UNSIGNED NOT NULL,CHANGE profilepicmaxsize profilepicmaxsize INT UNSIGNED NOT NULL
MySQL said:
Unknown column 'avatarmaxsize' in 'usergroup'
that was in phpmyadmin

[Kier]

You are running vB3, right?

[Dark Shogun]

Seems to have worked. I got no errors.

Dark Shogun

[Chris M]

Thanks Kier:)

Satan

[a43079]

You are running vB3, right?

yes it is vb3 fresh install i had to many hacks on my versioni 2 so i did a fresh install...

[Pogo]

yes it is vb3 fresh install i had to many hacks on my versioni 2 so i did a fresh install...

If you are using a table prefix you have to add it befire the usergroup tabla name.

If your table prefix is vb3_ your query would look like this
ALTER TABLE vb3_usergroup
CHANGE avatarmaxsize avatarmaxsize INT UNSIGNED NOT NULL,
CHANGE profilepicmaxsize profilepicmaxsize INT UNSIGNED NOT NULL

[a43079]

thank you it worked