OK correct syntax for postgres is select lang_val_id, 1+deleted, fieldvalues_id, value from fieldlanguagesvalues where language_id = 4 LIMIT 100 OFFSET 100;
I'll try to check your issue using postgres (hopefully soon :)) ) I can't see why you have error missing from client debug log :( can try to add logging ... On Wed, Jul 25, 2012 at 11:25 PM, Pascal Dallaire < pascal.dalla...@cre-gim.net> wrote: > Okay, here are the returns… > > From SQL: > ERROR: LIMIT #,# syntax is not supported > LINE 1 : ...e from fieldlanguagesvalues where language_id = 4 LIMIT 700,... > ^ > Use separate LIMIT and OFFSET clauses. > > From console when run with debug, I'm not sure what to look for, I checked > for number of the labels but they don't seem to be there > http://pastebin.com/nLBJHLSK > > I've used a lot of different versions, this one is : > apache-openmeetings-incubating-2.1.0.r1364829-23-07-2012_2307.tar.gz > > Thanks in again > Pascal > > Le 2012-07-25 à 12:00, Maxim Solodovnik a écrit : > > OK > one more try > > select lang_val_id, 1+deleted, fieldvalues_id, value from > fieldlanguagesvalues where language_id = 4 LIMIT 700,100; > > does it return correct values for labels? > can you try to load debug version: > localhost:5080/openmeetings/maindebug.as3.swf10.swf > and take a look at debug consoles? > > can you send the archive name you are using? > > > On Wed, Jul 25, 2012 at 8:39 PM, Pascal Dallaire < > pascal.dalla...@cre-gim.net> wrote: > >> Hi Maxim, >> Thanks for trying to help… >> >> I didn't put the string ids at first because the missing ones change all >> the time. >> Here are a few screenshots that show some of them (which are from the >> main menus): >> >> http://pastebin.com/1TNqnUtD >> >> I wonder why it worked beautiful earlier and now all versions I'm trying >> have those. >> I didn't make any changes to the server, I think I'll have to try >> installing on another machine (or locally on my laptop) just to test. >> >> Pascal >> >> >> Le 2012-07-24 à 22:54, Maxim Solodovnik a écrit : >> >> Usually it is not just "Error Missing" but "Error Missing (XXXX)" >> Can you provide string ids missing? (maybe couple of screen shots)? >> >> On Wed, Jul 25, 2012 at 12:35 AM, Pascal Dallaire < >> pascal.dalla...@cre-gim.net> wrote: >> >>> I'm having same problems with english as default language installed >>> >>> count: 1492 >>> >>> response from your sql >>> >>> Thanks again for trying! >>> >>> Pascal >>> >>> Le 2012-07-24 à 13:10, Maxim Solodovnik a écrit : >>> >>> select count(*) from fieldlanguagesvalues where language_id = 4; >>> >>> >>> >> >> >> -- >> WBR >> Maxim aka solomax >> >> >> > > > -- > WBR > Maxim aka solomax > > > -- WBR Maxim aka solomax
