Welcome to Geeklog, Anonymous Wednesday, November 27 2024 @ 09:37 pm EST
Geeklog Forums
Bugs in Geeklog 1.4.0 beta 1
Page navigation
Status: offline
rich00
Forum User
Newbie
Registered: 12/07/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.
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: 04/22/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
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: 12/17/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
This is the error:
Text 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: 01/12/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: 12/17/04
Posts: 340
Location:Sweden
Thanks Dirk, as always very fast and efficient
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
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: 01/12/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: 11/20/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?
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: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Status: offline
knuff
Forum User
Full Member
Registered: 12/17/04
Posts: 340
Location:Sweden
Status: offline
lokki
Forum User
Chatty
Registered: 03/19/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.
- 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: 11/20/05
Posts: 44
Location:Zurich
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Status: offline
TechSys
Forum User
Regular Poster
Registered: 12/02/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: 04/22/02
Posts: 292
Status: offline
suvi
Forum User
Chatty
Registered: 11/20/05
Posts: 44
Location:Zurich
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/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: 11/20/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;
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: 04/22/02
Posts: 292
Quote by Dirk:
Do you think this a problem with the language file or is Geeklog messing them up somehow?
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 EST. The time is now 09:37 pm.
- 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