Skip to main content ↑ ↓
Topic: ORDER BY id DESC ->(!) Error Processing Request (Read 3151 times) previous topic - next topic

ORDER BY id DESC ->(!) Error Processing Request

Hello,

I try today for first time PHPRad. Very nice. (I was using Codecharge for years.)
I managed to produce a nice looking website with my database.  :)) Great !!

But I got stucked in very simple things: I wanted to do ORDER BY id DESC and then I got 'Error Processing Request' with no data. Same with all tables.

What is the best way to debug ? Could you help me please.

Thanks.

PS: Is it possible to see the genereted SQL line ?

Re: ORDER BY id DESC ->(!) Error Processing Request

Reply #1 –
The problem was an accent (é) in the data. So I removed the (é) and it works.

But I need (éèà...) so what to do ? :o

 

Re: ORDER BY id DESC ->(!) Error Processing Request

Reply #2 –
Specify character settings per database. To create a database such that its tables will use a given default character set and collation for data storage, use a CREATE DATABASE statement like this:

CREATE DATABASE mydb
  DEFAULT CHARACTER SET utf8
  DEFAULT COLLATE utf8_general_ci;

Tables created in the database will use utf8 and utf8_general_ci by default for any character columns.