search

ctrlcctrlv / infinity

A vichan fork permitting users to create their own boards
Other
318 stars 149 forks source link

Main Tables Aren't Created on New Install #497

Open jimbo8098 opened 9 years ago

jimbo8098 commented 9 years ago

Yo,

Found another thing not quite right here. Looks like a bunch of the tables aren't created in the install.sql file. Does anyone have a blanked .sql backup of this?

2 I've confirmed are:

captchas newsplus

I managed to create captchas using:

create table captchas (cookie varchar(20),extra varchar(100),text varchar(10),created_at varchar(20));

I'm not sure if there's anything else that might be missing here so I think it's best I get a blanked copy of a working db before continuing.

--- Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/14853397-main-tables-aren-t-created-on-new-install?utm_campaign=plugin&utm_content=tracker%2F6417251&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F6417251&utm_medium=issues&utm_source=github).
jimbo8098 commented 9 years ago

Should note that the captchas tables does work but I'd rather this was as standard. Looks like much of the columns can vary in size depending on what your captcha parameters are.

ctrlcctrlv commented 9 years ago

captchas is in 8chan-captcha/dbschema.sql

8chan-captcha used to be a separate project from 8chan until I decided to merge them. Unfortunately I forgot to just merge the DB tables...

jimbo8098 commented 9 years ago

I was able to recreate the captchas dB to the point that it's now working. If anyone has the rest of the dB's this should be perfectly serviceable and the create above should be fine.

I'll provide a sqldump following successful install along with some of the other stuff I needed to do for this install. On 15 May 2015 02:18, "Fredrick Brennan" notifications@github.com wrote:

captchas is in 8chan-captcha/dbschema.sql

8chan-captcha used to be a separate project from 8chan until I decided to merge them. Unfortunately I forgot to just merge the DB tables...

— Reply to this email directly or view it on GitHub https://github.com/ctrlcctrlv/infinity/issues/497#issuecomment-102216085 .

jimbo8098 commented 9 years ago

I never managed to get the installation to work. May return to this later to attempt a fix.