Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Installation #15

Open
squirz96 opened this issue Aug 7, 2018 · 2 comments
Open

Installation #15

squirz96 opened this issue Aug 7, 2018 · 2 comments

Comments

@squirz96
Copy link

squirz96 commented Aug 7, 2018

#!/usr/bin/php Your databse options in includes/config.php are Server: 127.0.0.1 User: root Pasword: (omitted) Databse: Chan MySQL Error: Can't create database 'Chan'; database exists MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'year(Created), PRIMARY KEY (Continuity,Year,Id) ) ENGINE=InnoDB DEFAUL' at line 7 MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'year(Created), Topic int(11) NOT NULL, Content text NOT NULL DEFAULT '',' at line 5 MySQL Error: Specified key was too long; max key length is 767 bytes Downloading and installing jBBCode-1.3.0 Finished!

@yumi-xx
Copy link
Collaborator

yumi-xx commented Aug 11, 2018

The first error is just some SQL DB checking stuff that I will fix in a bit. You probably ran the script once before; deleting the database manually will resolve the "database exists error."

The second error ("There is an error in your SQL syntax") is a little more confusing. What SQL version are you using? It may not have the function year since that's where it seems to throw the error.

@yumi-xx yumi-xx closed this as completed Aug 11, 2018
@yumi-xx yumi-xx reopened this Aug 11, 2018
@squirz96
Copy link
Author

I am using mariadb server. 10.1.34-MariaDB

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants