Windows Mysql (modern)

[Beo]

A Database Error Occurred

Error Number: 1054

Unknown column 'id' in 'order clause'

SELECT * FROM (`news`) ORDER BY `id` desc LIMIT 10

I created news table myself, now it says this. I have no idea what id it's talking about because there is no columns in news table.

There are others after this, I'm sure.

Rep if anyone knows how to fix

Using modern AAC r267. (I don't even know if this is the correct one).

Also using; [8.60] OTServ (0.6.3) r.6052

 

[TGYoshi]

That's exactly the problem, there is no column 'id', and the query tries to sort the news table on the value in 'id'.

 

[Beo]

That's exactly the problem, there is no column 'id', and the query tries to sort the news table on the value in 'id'.

Fixed it.

A Database Error Occurred

Error Number: 1146

Table 'test.poll' doesn't exist

SELECT p.id, p.question, GROUP_CONCAT(a.answer SEPARATOR ';') AS answers, GROUP_CONCAT(a.id SEPARATOR ';') AS answers_id FROM poll p JOIN poll_answer a ON p.id = a.poll_id WHERE p.status = 1 AND date_start <= NOW() AND date_end >= NOW()

Now another...
This is going to be a long night I guess.

Ah, this is the one I was stuck at earlier.

A Database Error Occurred

Error Number: 1054

Unknown column 'p.question' in 'field list'

SELECT p.id, p.question, GROUP_CONCAT(a.answer SEPARATOR ';') AS answers, GROUP_CONCAT(a.id SEPARATOR ';') AS answers_id FROM poll p JOIN poll_answer a ON p.id = a.poll_id WHERE p.status = 1 AND date_start <= NOW() AND date_end >= NOW()

Any help would be much appreciated.

 

[TGYoshi]

Reading the error might help.

#1: Table poll does not exist, simple as that.
#2: In the table 2nd the column "question" does not exist in the table poll.

 

[Beo]

Reading the error might help.

#1: Table poll does not exist, simple as that.
#2: In the table 2nd the column "question" does not exist in the table poll.

Yup, I'm making all the tables and columns now.

Thanks.


Fixed those, now I can actually see my website.
When I change my design to Veans Worgen template I see this;



And get this error

Error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'k.unjustified' in 'where clause'

 

[Ninja]

Check the CSS path.

 

[Beo]

Check the CSS path.

C:\xampp\htdocs\templates\worgen

same path as the .tpl file