Welcome to Geeklog Thursday, April 02 2020 @ 09:15 am EDT

Geeklog Forums

Bugs in Geeklog 1.4.0 beta 1

Page navigation


Status: offline

rich00

Forum User
Newbie
Registered: 07/12/05
Posts: 1
The DB Backup feature seems to be broken following my otherwise-smooth upgrade to 1.4. Has anybody else seen this issue?


Backup file Size
geeklog_db_backup_2005_12_08_12_37_14.sql 665 Bytes
geeklog_db_backup_2005_12_07_22_29_18.sql 665 Bytes
geeklog_db_backup_2005_12_07_22_28_35.sql 665 Bytes


The files obviously don't contain any data:

-- MySQL dump 10.9
--
-- Host: localhost Database: weblog
-- ------------------------------------------------------
-- Server version 4.1.14-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES latin1 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


Running mysql-4.1.14 and non-CVS geeklog beta.

Status: offline

Euan

Forum User
Full Member
Registered: 22/04/02
Posts: 292
Sat 10 Dec 2005 05:44:45 UTC - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1. SQL in question: SELECT grp_id,grp_name FROM gl_groups WHERE grp_id IN (2,4,7,11,5,13,12,10,8,1,14,3,6,9,15,)

I get the above error when clicking on the edit link for a user. Latest cvs snapshot. Seems to be an extra comma or an unset item.

Cheers
-- Heather Engineering -- No job too small

Status: offline

knuff

Forum User
Full Member
Registered: 17/12/04
Posts: 340
Location:Sweden
Quote by THEMike: Get admin/blocks.php from cvs, or get the latest CVS nightly tarball.


I had the error with the wrongly bid.

I tried that one, and now I get another error.
It seems that there is a double AND AND in the select, but to be honest I really got lost when looking into block.php Mr. Green

This is the error:

PHP Formatted Code


Mon 12 Dec 2005 14:57:44 CET - 1064: You have an error in your SQL syntax near 'AND onleft=1 ORDER BY blockorder asc LIMIT 0,50' at line 1. SQL in question: SELECT * FROM gl_blocks WHERE 1 AND AND onleft=1 ORDER BY blockorder asc LIMIT 0,50;

 


Used block.php from nightly cvs - timestamp 12.12.2005 8 AM

Best Regards,
Boris
Vanrillaer.com - our Family Portal

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Quote by knuff: Used block.php from nightly cvs - timestamp 12.12.2005 8 AM

Better quote the $Id line. The version tagged

$Id: block.php,v 1.90 2005/12/11 11:36:10 ospiess Exp $

works just fine for me. Also make sure you've updated lib-admin.php, as most of the code for the lists is in that file. Current version as of this writing:

$Id: lib-admin.php,v 1.41 2005/12/11 22:51:03 dhaun Exp $

I don't get any SQL errors when listing, editing, creating, or deleting blocks.

bye, Dirk

Status: offline

knuff

Forum User
Full Member
Registered: 17/12/04
Posts: 340
Location:Sweden
Thanks Dirk, as always very fast and efficient Mr. Green

It was the lib-admin.php I was missing, as I didn´t want to update everything.

So now it works like a charm.

And just to be complete, I am using
$Id: block.php,v 1.86 2005/11/19 14:08:25 dhaun Exp $

Cheerz,
Boris

PS Great Nifty Release !!!
Vanrillaer.com - our Family Portal

Tom Duck

Anonymous
As admin, when I open the http://.../admin/user.php I have a user whose Full Name is given as "Geeklog Superuser". I have tried to fix the name by editing the user's profile (e.g., http://.../admin/user.php?mode=edit&uid=16), but save has no effect -- the Full Name is still "Geeklog Superuser". I also note that I cannot reset the user's passwords this way either.

Tom Duck

Anonymous
Quote by Tom Duck: As admin, when I open the http://.../admin/user.php I have a user whose Full Name is given as "Geeklog Superuser". I have tried to fix the name by editing the user's profile (e.g., http://.../admin/user.php?mode=edit&uid=16), but save has no effect -- the Full Name is still "Geeklog Superuser". I also note that I cannot reset the user's passwords this way either.


Sorry, just to clarify: The page where the Full Name information is not updated is http://.../admin/user.php?mode=edit&uid=16. The password fields are blank (probably intentional), but do seem to work. Apologies for the confusion.

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Tom Duck: As admin, when I open the http://.../admin/user.php I have a user whose Full Name is given as "Geeklog Superuser".

Do you see the same name regardless which user you edit? If so, it's your browser fooling you - many browsers these days store form contents and if your browser stored the content of the user edit form, it will always display that stored content instead of the actual user data.

In that case, try getting rid of the stored content (in the browser's preferences somewhere) or try using another browser.

bye, Dirk

Status: offline

suvi

Forum User
Chatty
Registered: 20/11/05
Posts: 44
Location:Zurich
I am using MySQL 5 and tried to enter a new PHP Block.
But I run into this, from error.log:

12/13/05 13:43:19 - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''','language','','phpblock','0','','all','','','0','phpblock_MyMenu',1,2,4,3,2,2' at line 1. SQL in question: REPLACE INTO gl_blocks (bid,name,title,help,type,blockorder,content,tid,rdfurl,rdfupdated,rdflimit,phpblockfn,onleft,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,is_enabled) VALUES (,'','language','','phpblock','0','','all','','','0','phpblock_MyMenu',1,2,4,3,2,2,2,1)


anybody else with this problem?

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Quote by suvi: I am using MySQL 5 and tried to enter a new PHP Block.
But I run into this, from error.log:

This is a known big in the beta, as reported on the first page of this thread. It has since been fixed in CVS (also see my above discussion with knuff).

bye, Dirk

Status: offline

knuff

Forum User
Full Member
Registered: 17/12/04
Posts: 340
Location:Sweden
Just wanted to add that if you update only block.php and lib-admin.php some other things will not work due to changes in lib-admin.php.

Therefore you should consider using the full cvs, or at least the full admin section of the cvs.

Hence the name beta Mr. Green
Vanrillaer.com - our Family Portal

Status: offline

lokki

Forum User
Chatty
Registered: 19/03/05
Posts: 59
Quote by THEMike: 1) Geeklog's syndication system doesn't follow HTTP Redirect codes, and fails to syndicate feeds behind redirects

- fixed in CVS.

2) It is not possible to create a new block.

- fixed in CVS.


I downloaded the nightly CVS tarball of Gl1.4.0b1. What files should i replace to make new blocks create?

Thanks

Status: offline

suvi

Forum User
Chatty
Registered: 20/11/05
Posts: 44
Location:Zurich
I tried to untar the nightly but I got

C:wampwwwgeeklog-cvs-nightly.tar.gz: Unexpected end of archive
C:wampwwwgeeklog-cvs-nightly.tar.gz: CRC failed in Cwampwwwgeeklog-cvs-nightly.tar.gz. The file is corrupt


Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
@suvi: The tarball on the server unpacks just fine. Try downloading it again.

@lokki: See the above discussion ...

bye, Dirk

Status: offline

TechSys

Forum User
Regular Poster
Registered: 02/12/03
Posts: 90
Just wanted to add that if you update only block.php and lib-admin.php some other things will not work due to changes in lib-admin.php.

So far the only other thing I've had to replace is story.php. After updating block.php and lib-admin.php, I went to create a new story and had an sql error. Once I updated it, no more problems..

Just thought I'd throw that in in case somebody else ran into the same problem.
http://70.145.174.180/

Status: offline

Euan

Forum User
Full Member
Registered: 22/04/02
Posts: 292
The characters for days of the week along the small calendars of previous and next month in the month view are corrupted in Japanese_utf-8. Setting language to Japanese_EUC displays days correctly. This has been so at least since Geeklog 1.3.11sr1.
-- Heather Engineering -- No job too small

Status: offline

suvi

Forum User
Chatty
Registered: 20/11/05
Posts: 44
Location:Zurich
to dirk: I have to go through a stupid proxy. There was also a problem
downloading something from geeklog because of that.
I think this very very very stupid proxy (I hate proxys, they are useless)
is the problem that I can't untar the file.

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Quote by euan: The characters for days of the week along the small calendars of previous and next month in the month view are corrupted in Japanese_utf-8. Setting language to Japanese_EUC displays days correctly.

Do you think this a problem with the language file or is Geeklog messing them up somehow?

bye, Dirk

Status: offline

suvi

Forum User
Chatty
Registered: 20/11/05
Posts: 44
Location:Zurich
I have downloaded the nightly build today (16.Dez), with another internet connection :-), an replaced the whole admin section. Unfortunatly

block, stories and user do not work.

(I am using mysql 5 ) on users I get this sql error:


12/16/05 10:15:46 - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND gl_users.uid > 1 ORDER BY uid asc LIMIT 0,50' at line 1. SQL in question: SELECT gl_users.uid,username,fullname,email,photo,regdate,lastlogin FROM gl_users LEFT JOIN gl_userinfo ON gl_users.uid=gl_userinfo.uid WHERE 1 AND AND gl_users.uid > 1 ORDER BY uid asc LIMIT 0,50;


on stories


12/16/05 10:24:26 - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (tid = 'General' OR tid = 'GeekLog' OR tid = 'Finance' OR tid = 'POTS' OR t' at line 1. SQL in question: SELECT gl_stories.*, gl_users.username, UNIX_TIMESTAMP(date) AS unixdate FROM gl_stories LEFT JOIN gl_users ON gl_stories.uid=gl_users.uid WHERE 1 AND AND (tid = 'General' OR tid = 'GeekLog' OR tid = 'Finance' OR tid = 'POTS' OR tid = 'Event' OR tid = 'People') ORDER BY unixdate desc LIMIT 0,50;


and on blocks

12/16/05 10:26:00 - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND onleft=1 ORDER BY blockorder asc LIMIT 0,50' at line 1. SQL in question: SELECT * FROM gl_blocks WHERE 1 AND AND onleft=1 ORDER BY blockorder asc LIMIT 0,50;

Status: offline

Euan

Forum User
Full Member
Registered: 22/04/02
Posts: 292
Quote by Dirk:
Do you think this a problem with the language file or is Geeklog messing them up somehow?

I had a look at all the relevant files quickly. I can see nothing wrong with calendar.php or the template files or language files. Also, calendar.class.php seems fine - but I only glanced through it once. If you could, please have a quick look at the calendar class and see if you can see anything. I'll have another look later.

I wonder if this is a problem with PHP and UTF8? The fact that EUC works and UTF8 does not seems odd to me.

Cheers, Euan.
-- Heather Engineering -- No job too small

Page navigation

All times are EDT. The time is now 09:15 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content