Need help with Znote Aac website

[Chubby Bunny]

I can get the website to work but when i click anything nothing happens, it just reloads the page quickly.. What am i doing wrong?

 

[Chubby Bunny]

When i copy paste into the database at phpmyadmin this comes

Error
SQL query:


CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`limit` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB



MySQL said:

#1215 - Cannot add foreign key constraint

 

[Saint Spear]

there is button foreign key , unbox it xD

 

[Chubby Bunny]

there is button foreign key , unbox it xD

where? xd sorry this is my first time creating a ot :S

there is button foreign key , unbox it xD

Error
Static analysis:

1 errors were found during analysis.

1. Unrecognized statement type. (near "Error" at position 0)

SQL query:

Error SQL query: CREATE TABLE IF NOT EXISTS `znote_guild_wars` ( `id` int(11) NOT NULL AUTO_INCREMENT, `limit` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB MySQL said: Documentation

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 'Error
SQL query:

CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
`id` i' at line 1

Now this happened

wait, gona try something

there is button foreign key , unbox it xD

Okay, first problem fixed! no more error on the phpmyadmin (Y) But i still cant press any buttons on the website itself :S

 

[Saint Spear]

Contact me via discord Budex#6734
ill try to find some free time to help you.

 

[Webtimize]

CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`limit` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB

Here's a fix for your first issue, for anyone stumbling upon the same problem

Also, please consider editing your previous post with new information instead of posting a new reaction. There is no need to double post.

 

[Saint Spear]

CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`limit` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB

Here's a fix for your first issue, for anyone stumbling upon the same problem

Also, please consider editing your previous post with new information instead of posting a new reaction. There is no need to double post.

The problem was about config.php he edited wrong tfs version. I passed him some codes too because he didnt insert totally Znote AAC schema, But its all working now !