Main Tables Aren't Created on New Install

[jimbo8098]

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! We accept bounties via Bountysource.

[jimbo8098]

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]

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]

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
#497 (comment)
.

[jimbo8098]

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