Hier einen weiteren Bug-Report für die aktuelle SVN Version:
Wenn ich in der Terminverwaltung im Feld "Ort" eine Adresse angebe, wird nach jedem Bearbeiten und anschliessenden Speichern das Land ein weiteres Mal angehängt, ohne Leerschlag zum vorherigen Text. Das gibt also nach ein paar Speichern Adressen wie:
Code: Alles auswählen
Königsallee 13, 40212, Düsseldorf, DeutschlandDeutschlandDeutschlandDeutschlandCode: Alles auswählen
S Q L - E R R O R
CODE: 1054
Unknown column '9' in 'where clause'
B A C K T R A C E
FILE: adm_program/system/db/db_mysql.php
LINE: 62
CALL: DBCommon->db_error()
FILE: adm_program/system/db/db_mysql.php
LINE: 164
CALL: DBMySQL->db_error()
FILE: adm_program/modules/dates/dates.php
LINE: 495
CALL: DBMySQL->query()
Code: Alles auswählen
[21-Nov-2011 23:41:04] --------------------------------------------------------------------------------
C:/xampp/htdocs/admidio-trunk/adm_program/modules/dates/dates_function.php
? dat_id=8&mode=1
[21-Nov-2011 23:41:04] SELECT prf_name, prf_value
FROM demo_preferences, demo_organizations
WHERE org_shortname = 'DEMO'
AND prf_org_id = org_id
AND prf_name IN ('forum_version','enable_forum_interface')
[21-Nov-2011 23:41:04] SHOW COLUMNS FROM demo_sessions
[21-Nov-2011 23:41:04] SELECT * FROM demo_sessions
WHERE ses_session_id = 'rbqa5mii03uslpubrtcds23me5'
[21-Nov-2011 23:41:04] UPDATE demo_sessions SET ses_timestamp = '2011-11-21 23:41:04'
WHERE ses_id = '5'
[21-Nov-2011 23:41:04] SHOW COLUMNS FROM demo_dates
[21-Nov-2011 23:41:04] SELECT * FROM demo_dates , demo_categories
WHERE dat_cat_id = cat_id
AND dat_id = 0
[21-Nov-2011 23:41:04] SELECT * FROM demo_dates , demo_categories
WHERE dat_cat_id = cat_id
AND dat_id = 8
[21-Nov-2011 23:41:04] START TRANSACTION
[21-Nov-2011 23:41:04] UPDATE demo_dates SET dat_begin = '2011-11-23 07:00:0' , dat_end = '2011-11-23 12:00:0' , dat_timestamp_change = '2011-11-21 23:41:04' , dat_max_members = 15
WHERE dat_id = '8'
[21-Nov-2011 23:41:04] DELETE FROM demo_date_role WHERE dtr_dat_id = 8
[21-Nov-2011 23:41:04] SHOW COLUMNS FROM demo_date_role
[21-Nov-2011 23:41:04] INSERT INTO demo_date_role ( dtr_dat_id ) VALUES ( 8 )
[21-Nov-2011 23:41:04] COMMIT
[21-Nov-2011 23:41:05] --------------------------------------------------------------------------------
C:/xampp/htdocs/admidio-trunk/adm_program/modules/dates/dates.php
? mode=actual&headline=Termine&calendar=
[21-Nov-2011 23:41:05] SELECT prf_name, prf_value
FROM demo_preferences, demo_organizations
WHERE org_shortname = 'DEMO'
AND prf_org_id = org_id
AND prf_name IN ('forum_version','enable_forum_interface')
[21-Nov-2011 23:41:05] SHOW COLUMNS FROM demo_sessions
[21-Nov-2011 23:41:05] SELECT * FROM demo_sessions
WHERE ses_session_id = 'rbqa5mii03uslpubrtcds23me5'
[21-Nov-2011 23:41:05] UPDATE demo_sessions SET ses_timestamp = '2011-11-21 23:41:05'
WHERE ses_id = '5'
[21-Nov-2011 23:41:05] SELECT * FROM demo_organizations
WHERE org_org_id_parent = 1
[21-Nov-2011 23:41:05] SELECT COUNT(DISTINCT dat_id) as count
FROM demo_date_role, demo_dates, demo_categories
WHERE dat_cat_id = cat_id
AND ( cat_org_id = 1
OR ( dat_global = 1
AND cat_org_id IN ('2, 1')
)
)
AND dat_id = dtr_dat_id
AND ( dtr_rol_id IS NULL
OR dtr_rol_id IN (SELECT mem_rol_id
FROM demo_members mem2
WHERE mem2.mem_usr_id = 1
AND mem2.mem_begin <= dat_begin
AND mem2.mem_end >= dat_end) ) AND ( dat_begin >= '2011-11-21'
OR dat_end > '2011-11-21 00:00:00' )
[21-Nov-2011 23:41:05] SELECT DISTINCT cat.*, dat.*, mem.mem_usr_id as member_date_role, mem.mem_leader,
cre_surname.usd_value as create_surname, cre_firstname.usd_value as create_firstname,
cha_surname.usd_value as change_surname, cha_firstname.usd_value as change_firstname
FROM demo_date_role dtr, demo_categories cat, demo_dates dat
LEFT JOIN demo_user_data cre_surname
ON cre_surname.usd_usr_id = dat_usr_id_create
AND cre_surname.usd_usf_id = 1
LEFT JOIN demo_user_data cre_firstname
ON cre_firstname.usd_usr_id = dat_usr_id_create
AND cre_firstname.usd_usf_id = 2
LEFT JOIN demo_user_data cha_surname
ON cha_surname.usd_usr_id = dat_usr_id_change
AND cha_surname.usd_usf_id = 1
LEFT JOIN demo_user_data cha_firstname
ON cha_firstname.usd_usr_id = dat_usr_id_change
AND cha_firstname.usd_usf_id = 2
LEFT JOIN demo_members mem
ON mem.mem_usr_id = 1
AND mem.mem_rol_id = dat_rol_id
AND mem_begin <= '2011-11-21'
AND mem_end > '2011-11-21'
WHERE dat_cat_id = cat_id
AND ( cat_org_id = 1
OR ( dat_global = 1
AND cat_org_id IN (2, 1) ))
AND dat_id = dtr_dat_id
AND ( dtr_rol_id IS NULL
OR dtr_rol_id IN (SELECT mem_rol_id
FROM demo_members mem2
WHERE mem2.mem_usr_id = 1
AND mem2.mem_begin <= dat_begin
AND mem2.mem_end >= dat_end) )
AND ( dat_begin >= '2011-11-21'
OR dat_end > '2011-11-21 00:00:00' ) ORDER BY dat_begin ASC
LIMIT 10 OFFSET 0
[21-Nov-2011 23:41:05] SELECT DISTINCT cat_name, cat_sequence
FROM demo_categories, demo_dates dat
WHERE cat_type = 'DAT'
AND dat_cat_id = cat_id
AND ( cat_org_id = 1
OR ( dat_global = 1
AND cat_org_id IN (2, 1)
)
)
AND ( dat_begin >= '2011-11-21'
OR dat_end > '2011-11-21 00:00:00' ) ORDER BY cat_sequence ASC
[21-Nov-2011 23:41:05] SHOW COLUMNS FROM demo_dates
[21-Nov-2011 23:41:05] SELECT * FROM demo_dates , demo_categories
WHERE dat_cat_id = cat_id
AND dat_id = 0
[21-Nov-2011 23:41:05] SELECT * FROM demo_dates , demo_categories
WHERE dat_cat_id = cat_id
AND dat_id = 0
[21-Nov-2011 23:41:05] SELECT * FROM demo_dates , demo_categories
WHERE dat_cat_id = cat_id
AND dat_id = 8
[21-Nov-2011 23:41:05] SELECT DISTINCT mem_usr_id
FROM demo_members
WHERE mem_rol_id="9"
[21-Nov-2011 23:41:05] 1054: Unknown column '9' in 'where clause'
[21-Nov-2011 23:41:05] --------------------------------------------------------------------------------
C:/xampp/htdocs/admidio-trunk/adm_program/modules/dates/rss_dates.php
? headline=Termine
[21-Nov-2011 23:41:05] SELECT prf_name, prf_value
FROM demo_preferences, demo_organizations
WHERE org_shortname = 'DEMO'
AND prf_org_id = org_id
AND prf_name IN ('forum_version','enable_forum_interface')
[21-Nov-2011 23:41:05] SHOW COLUMNS FROM demo_sessions
[21-Nov-2011 23:41:05] SELECT * FROM demo_sessions
WHERE ses_session_id = 'rbqa5mii03uslpubrtcds23me5'
[21-Nov-2011 23:41:05] SELECT * FROM demo_organizations
WHERE org_org_id_parent = 1
[21-Nov-2011 23:41:05] SELECT cat.*, dat.*,
cre_surname.usd_value as create_surname, cre_firstname.usd_value as create_firstname,
cha_surname.usd_value as change_surname, cha_firstname.usd_value as change_firstname
FROM demo_categories cat, demo_dates dat
LEFT JOIN demo_user_data cre_surname
ON cre_surname.usd_usr_id = dat_usr_id_create
AND cre_surname.usd_usf_id = 1
LEFT JOIN demo_user_data cre_firstname
ON cre_firstname.usd_usr_id = dat_usr_id_create
AND cre_firstname.usd_usf_id = 2
LEFT JOIN demo_user_data cha_surname
ON cha_surname.usd_usr_id = dat_usr_id_change
AND cha_surname.usd_usf_id = 1
LEFT JOIN demo_user_data cha_firstname
ON cha_firstname.usd_usr_id = dat_usr_id_change
AND cha_firstname.usd_usf_id = 2
WHERE dat_cat_id = cat_id
AND ( cat_org_id = 1
OR ( dat_global = 1
AND cat_org_id IN (2, 1) ))
AND ( dat_begin >= '2011-11-21 23:41:05'
OR dat_end >= '2011-11-21 23:41:05' )
ORDER BY dat_begin ASC
LIMIT 10
[21-Nov-2011 23:41:05] SHOW COLUMNS FROM demo_dates
[21-Nov-2011 23:41:05] SELECT * FROM demo_dates , demo_categories
WHERE dat_cat_id = cat_id
AND dat_id = 0
