[1.7 / 1.7.1] MySQL v4.1 = ACP doesnt show database size

[V@no]

IMHO MySQL v4.1 is not a major upgrade from v3 or even v4.0 but its major pain in the @$$..

Well, anyway, after upgrading I've noticed that database size in ACP shows n/a
After investigation I found out that some database "variables" for tables in v4.1 has been changed. One of them is "Type" parameter that used to determin what type of table is it (MyISAM, ISAM, HEAP, InnoDB, etc). As of v4.1 this "variable" was renamed to "Engine" which makes 4images ignore it and show "n/a" instead.


The fix is very simple, in includes/db_utils.php find:

Code: [Select]

        if (eregi('^(MyISAM|ISAM|HEAP|InnoDB)$', $row['Type'])) {Replace with:

Code: [Select]

        if ((isset($row['Type']) && eregi('^(MyISAM|ISAM|HEAP|InnoDB)$', $row['Type'])) || (isset($row['Engine']) && eregi('^(MyISAM|ISAM|HEAP|InnoDB)$', $row['Engine']))) {

This fix should not affect any other versions of MySQL.

P.S.
Also some people may see some error messages such as:

Notice: Undefined index: Type in /path/to/4images/includes/db_utils.php on line 184

this fix should solve it too.

[Guerillia]

Es funktioniert trotz des Patches nicht. im ACP wird der Header und das linke Menü geladen, aber das "mittlere" fehlt komplett. Nach einer Weile bekommt man einen 500er und die oben beschrieben Fehlermeldung "Undefined index: Type in /path/to/4images/includes/db_utils.php on line 184"

[Acidgod]

Stimmt den die mySQL Version?

[Guerillia]

--> Client API version    4.1.14

[V@no]

Try now, I've updated the line, it should not show you "Underfined index" error anymore. Cant say if it will fix the 500 error though. if not, perhaps you should contact your hoster, something is wrong with the server.

[Guerillia]

It works fine    Thx a lot

[linux_rh]

hello there i got broblem with 4images  after moving from hosting  has Mysql 4.0.25  and  shift  to MySql 4.1.13

when i uplaod it  i got error dublcated syntcs  and  the  when i got help from someone  and  that was uploaded  when i want to get into control panle  i can  do that  but  i can not get  any opstions there  i got error 


is  there any way to solve  this problem ?

althought  i register  4images  and  i have  more then 800 hunderd pic

thank you

[V@no]

What error? is that error related to "ACP doesnt show database size"? if not, then please start a new topic in troubleshooting section and be more describtive on what exactly is the problem and what error messages.

Also, please read forum rules.

P.S. please slow down during typing too...too many typos for a single post

[linux_rh]

regardding  the probelm i said  and  the error   i  am using arabic languge  and when  i shift from mysql server 4.0.25
to mysql 4.1.13  i got   14 database table written  there  althought 4images tables are 15 by difulat
2nd i got  this erroe

Server: localhost   Database: samauae_mywork

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

Error
SQL query:

INSERT INTO 4images_wordlist( word_text, word_id )
VALUES (

'Ρݭ姬4
)

MySQL said: 

#1062 - Duplicate entry '???' for key 2

brows

SQL query:

SELECT *
FROM
MySQL said: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

this the  link  http://www.samauae.com/ad1

[V@no]

huh? the error you showed comes from phpmyadmin and not from 4images...are you sure you are on the right forum?
And as I said, your question has nothing to do with this topic, please DO NOT CONTINUE here.

[linux_rh]

thank you

bye

[ladyoz]

Woohoo!  I just started having this silly problem today, and for no reason at all that I could see.  This fixed it - thanks V@no!