Problem with FluxCP purchase, item, mob database

[eKoh]

Well, I really don't know the way to fix this (happens the same in account, purchase, item, mob database options)

As it says its a misconfiguration, but I've seen in my configuration and its ok, I think that its cause i dont have the items, mob and account tables in my database but how to configure them (if i am right)?

I will really appreciate any help from you guys, thank you

Edited July 31, 2012 by eKoh

[Brynner]

Well, I really don't know the way to fix this (happens the same in account, purchase, item, mob database options)

As it says its a misconfiguration, but I've seen in my configuration and its ok, I think that its cause i dont have the items, mob and account tables in my database but how to configure them (if i am right)?

I will really appreciate any help from you guys, thank you

just this to your sql.

mob_db.sql, mob_db2.sql, mob_db_re.sql, item_db.sql, item_db2.sql and item_db_re.sql.

[eKoh]

actually i am using 3CeAm, will those works? thanks

[Brynner]

actually i am using 3CeAm, will those works? thanks

yup you should add this. item_db.sql, item_db2.sql, mob_db.sql and mob_db2.sql

[eKoh]

When I upload those files, item_db and mob_db, appears these:

I think it is normal but if it is not, whats the problem then? thank you

ok, i've seen in another post that it is solved by granting permission for the user of FluxCP, but I dont know to grant any permission, will someone help me with this? i am kinda noob with this :/

[Asura]

Hi eKoh,

I think the issue is the fact that the MySQL account you are using for your FluxCP, does not have the proper privileges/access to create the temporary table. You would need to add these permissions for the user, and make sure that the MySQL user can be accessed by your webhost; not just the 'localhost/127.0.0.1'.

[eKoh]

hmm and how to add permissions by myself? I have access to the mysql

[Aries]

you have to add a priviledge to that mysql user to allow creating temporary table.

HOW TO: GRANT priviledges

[Chok Designer]

what is this in myphpadmin?...

The additional features for working with linked tables have been deactivated. To find out why click here.

Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user 'root'.

SOLVED!

Edited September 11, 2012 by gniryudan