· 9 years ago · Dec 08, 2016, 01:08 PM
1Hi again,
2
3I get these errors (everything worked before I connected it to my db - drops&crates and airdrops)
4
5```
6Error - no MetaName string type for userdata (AGH!)
7[Prometheus] DB Connection successful
8
9Cannot add foreign key constraint (CREATE TABLE IF NOT EXISTS `ps2_keypersistence` (`id` INT(11) NOT NULL AUTO_INCREMENT, `material` VARCHAR(255) NOT NULL, `validCrate` INT(11) NOT NULL, `itemPersistenceId` INT(11) NOT NULL, PRIMARY KEY (`id` ASC), CONSTRAINT `FK_3232399523` FOREIGN KEY (`validCrate`) REFERENCES `ps2_itempersistence` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `FK_4097311878` FOREIGN KEY (`itemPersistenceId`) REFERENCES `ps2_itempersistence` (`id`) ON DELETE CASCADE ON UPDATE R[Pointshop2]Failed to initialize Model KeyPersistence(0: 0)
10WARNIG: uncaught error
110 0
12Cannot add foreign key constraint (CREATE TABLE IF NOT EXISTS `ps2_cratepersistence` (`itemMap` TEXT NULL, `material` VARCHAR(255) NOT NULL, `id` INT(11) NOT NULL AUTO_INCREMENT, `itemPersistenceId` INT(11) NOT NULL, PRIMARY KEY (`id` ASC), CONSTRAINT `FK_1399851057` FOREIGN KEY (`itemPersistenceId`) REFERENCES `ps2_itempersistence` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT) ENGINE=InnoDB)
13[Pointshop2]Failed to initialize Model CratePersistence(0: 0)
14GLib.Resources : Compressing resource Pointshop2/outfits took 20.11 ms (109.02 KiB to 11.74 KiB).
15GLib.Resources : Compressing resource Pointshop2/settings took 624.08 µs (3.76 KiB to 559.00 B).
16Table 'smokinhe_sa_ps2.ps2_cratepersistence' doesn't exist (SELECT `ps2_cratepersistence`.`itemMap` AS `ps2_cratepersistence.itemMap`,`ps2_cratepersistence`.`material` AS `ps2_cratepersistence.material`,`ps2_cratepersistence`.`id` AS `ps2_cratepersistence.id`,`ps2_cratepersistence`.`itemPersistenceId` AS `ps2_cratepersistence.itemPersistenceId`,`ItemPersistence`.`price` AS `ItemPersistence.price`,`ItemPersistence`.`id` AS `ItemPersistence.id`,`ItemPersistence`.`ranks` AS `ItemPersistence.ranks`,`ItemPersisWARNIG: uncaught error
170 SQL Error
18[Pointshop2] Couldn't load persistent items: 0 - SQL Error
19Table 'smokinhe_sa_ps2.ps2_keypersistence' doesn't exist (SELECT `ps2_keypersistence`.`id` AS `ps2_keypersistence.id`,`ps2_keypersistence`.`material` AS `ps2_keypersistence.material`,`ps2_keypersistence`.`validCrate` AS `ps2_keypersistence.validCrate`,`ps2_keypersistence`.`itemPersistenceId` AS `ps2_keypersistence.itemPersistenceId`,`CratePersistence`.`price` AS `CratePersistence.price`,`CratePersistence`.`id` AS `CratePersistence.id`,`CratePersistence`.`ranks` AS `CratePersistence.ranks`,`CratePersistence
20```
21
22Everything else that depends on the database in the pointshop works fine though...
23With drops&crates it won't even load, and with airdrops only it won't show the button to configure it
24
25Sorry for the late reply