ffDKP question

[Zyaan]

ok, so I was trying to host the ffdkp on the free hosting site, and I did everything and whatnot. After pressing install, I received this error,

"SQL query error

Query: CREATE VIEW `eqdkp_v_member_data_lifetime` AS SELECT m.member_id, m.member_name, m.member_raidcount AS raid_count, m.member_raidcount / count( DISTINCT ra.raid_id ) AS raid_percent FROM eqdkp_raids ra, eqdkp_members m WHERE ra.raid_date >= m.member_firstraid GROUP BY m.member_id
Message: CREATE VIEW command denied to user '242994_zyaan'@'182.148.2.1' for table 'eqdkp_v_member_data_lifetime'
Code: 1142"

What exactly did i go wrong here?

I did make database/username

[tyraravenlocke]

Erm.. your user doesn't have create permissions on that data base.. or perhaps more specifically create view..

Are you sure you were logged in as a dbo role?

[Zyaan]

I had everything checked on the permissions for user D:

[DionyShiva]

Mysql docs say that's indeed a permission problem.

[Zyaan]

Oh ok, ill try it out one more time after this limbus. I'll let you guys know how it goes

[Zyaan]

Okay so , I double checked the permissions.

the following that is checked are:

SELECT,
INSERT,
UPDATE,
DELETE,
CREATE,
DROP,
INDEX,
ALTER,
LOCK TABLES

The error came out the same as above.

[tyraravenlocke]

There's specifically a create view priveledge in mysql:

As of version 5.x or so:

http://dev.mysql.com/doc/refman/5.0/...-provided.html

So I suspect that your problem is that you need that permission checked on for your server.

Depending on your host.. and whether or not its a realized view they may not allow random users to make views. This is because unrealized views are basically run time sql commands, these would be fairly easy to sqlinject and start trying to hack.

But, this is all supposition w/o knowing what version of mysql you are running etc.. but check into it ^^

Good luck.

[DionyShiva]

You need at least the CREATE VIEWS permission too.

[nitsuj]

I'm sure someone else would say it, but have you tried just using www.guildwork.com ?

Stanislav has done some awesome things there.