Suche

[klauspeter]

Mal hallo sagen
Leider kann ich im  Annoncen modul keine Kategorien erstellen.
Weiss vielleicht jemand warum

[Webfan]

Moin,
hast Du die Tabelle für die Kategorien erstellt?
( {prefix} anpassen!)

CREATE TABLE `{prefix}_annoncen_cats` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`id_parent` INT( 11 ) NOT NULL ,
`name` VARCHAR( 255 ) NOT NULL ,
`beschreibung` TEXT NOT NULL
) ENGINE = MYISAM ;

mfg

[klauspeter]

Mal danke sagen
hab alle tabellen erstellt

Fehler beim Speichern.

[Webfan]

fehler beim Schreiben kommt jetzt

Kannst Du das präzisieren?
Bitte schalte mal den Debug modus an (in den Admin Einstellungen) und poste mal die Meldungen (beim Erstellen der Kategorien).

mfg

[klauspeter]

Habs dir mal kopiert


SMFCookie58 => a:4:{i:0;i:1;i:1;s:40:"01bb59920f9f402347ac361b04ec7536ae6dcb97&am
p;quot;;i:2;i:1507139533;i:3;i:0;}
SMFCookie840 => a:4:{i:0;i:1;i:1;s:40:"2a5d496c1a96e421e6cad8d67ace53631fe72c6e&am
p;quot;;i:2;i:1507137566;i:3;i:0;}
admin => a2xhdXM6ZGJhMDA3OWYxY2IzYTNiNTZlMTAyZGQ1ZTA0ZmEyYWY6
fusion59861_visited => yes
fusionH26ax_visited => yes
lang => german
mx8121ECFF813714D21F62C4BE9803F2 => b6dcc600939b1b1bbe47285a0b824a1e
mxC39EF4E1CC897629F03D7A3122912A => 85989ac8d6591e68d8cc119c4f3af93e
mxC546D3A584003973BA06288341D933 => 287863eae7f81eb4693e27ac9d1501fd
tab_editoradmin => 3
tab_modadmin => 0
tab_stat_visitors => 1
tab_usersconfig => 4
tab_ya_edituser => 0
user => MjprbGF1czpkYmEwMDc5ZjFjYjNhM2I1NmUxMDJkZDVlMDRmYTJhZjoxMDo6MDowOjA6MDo6NDA
5Ng==
sql-Anfragen:
select * from {prefix}_authors where aid='klaus'
SELECT u.*, IFNULL((YEAR(CURRENT_DATE) - YEAR(u.user_bday)) - ( RIGHT(CURRENT_DATE,5) < RIGHT(u.user_bday,5)), 0) AS user_age, a.aid AS admin_name, a.radminsuper AS admin_sys FROM {prefix}_users AS u LEFT JOIN {prefix}_authors AS a ON a.user_uid = u.uid WHERE uid=2 AND user_stat=1
SELECT ban_val FROM {prefix}_user_ban WHERE ban_type='ban_ip' AND ban_val='95.88.192.99'
SELECT mid, title as name, active, view, custom_title FROM {prefix}_modules WHERE title='Annoncen'
INSERT INTO {prefix}_annoncen_cats SET id_parent='0', name='klaus', beschreibung='klaus'
SELECT * FROM {prefix}_annoncen_cats ORDER BY id_parent ASC
SELECT * FROM {prefix}_annoncen_cats ORDER BY id_parent ASC
select main_module from {prefix}_main WHERE main_module <> ''
SELECT m.title FROM {prefix}_modules AS m ORDER BY m.title ASC
SELECT block_id FROM {prefix}_groups_blocks WHERE (group_id=1)
SELECT * FROM {prefix}_blocks WHERE (active=1) AND ((blanguage='german' OR blanguage='')) AND ((view = 0) OR (view = 2) OR (view = 1 AND bid in(5,6,7,19)) OR (view = 4)) AND position NOT IN('c','d') ORDER BY position, weight ASC
SELECT title FROM {prefix}_modules WHERE active=1
select count(faq_id) from {prefix}_faqnew
select count(pid) from {prefix}_gallery_pictures_newpicture
select count(id) from {prefix}_nukebook_queue
select count(id) from {prefix}_reviews WHERE active='0'
select count(qid) from {prefix}_queue
select count(lid) from {prefix}_links_newlink
select count(requestid) from {prefix}_links_modrequest where brokenlink=0
select count(requestid) from {prefix}_links_modrequest where brokenlink=1
SELECT id, pid, title, description, url, expanded, target FROM {prefix}_menu WHERE bid=44 ORDER BY pid,weight,id ASC
SELECT SUM(hits) FROM `{prefix}_stats` WHERE hits > 0 AND STR_TO_DATE(CONCAT(year, '-', month, '-', `date`), '%Y-%c-%e') >= '2011-9-18'
SELECT id, pid, title, description, url, expanded, target FROM {prefix}_menu WHERE bid=35 ORDER BY pid,weight,id ASC
SELECT title, custom_title FROM {prefix}_modules WHERE active=1 AND main_id='Modules_two'
SELECT id, pid, title, description, url, expanded, target FROM {prefix}_menu WHERE bid=19 ORDER BY pid,weight,id ASC
SELECT COUNT(uid), MAX(uid) FROM {prefix}_users WHERE user_stat=1
SELECT u.*, IFNULL((YEAR(CURRENT_DATE) - YEAR(u.user_bday)) - ( RIGHT(CURRENT_DATE,5) < RIGHT(u.user_bday,5)), 0) AS user_age, a.aid AS admin_name, a.radminsuper AS admin_sys FROM {prefix}_users AS u LEFT JOIN {prefix}_authors AS a ON a.user_uid = u.uid WHERE uid=3
SELECT Count(ip) FROM {prefix}_visitors WHERE time>1318526455 AND uid=0
SELECT uname FROM {prefix}_users WHERE ((uname Not In ('Gast')) AND (user_lastvisit >= 1318526455) AND (user_stat=1) AND (user_lastmod<>'logout')) ORDER BY uname
SELECT read_msg, Count(msg_id) FROM {prefix}_priv_msgs WHERE to_userid=2 GROUP BY read_msg
SELECT Count(gid) FROM {prefix}_userguest WHERE touserid='2' AND touser = 'klaus' AND dummy=0
SELECT COUNT(uid) FROM {prefix}_users WHERE user_regtime >= 1318456800 AND user_stat=1 AND uname NOT IN('Gast')
SELECT COUNT(uid) FROM {prefix}_users WHERE user_regtime >= 1318370400 AND user_regtime < 1318456800 AND user_stat=1 AND uname NOT IN('Gast')
SELECT pollID, pollTitle, voters FROM {prefix}_poll_desc WHERE (planguage LIKE 'german%' OR planguage = '') AND artid='0' AND pollactive=1 ORDER BY pollID DESC LIMIT 1
SELECT optionText, optionCount, voteID FROM {prefix}_poll_data WHERE (pollID=1) AND (optionText<>'') ORDER BY voteID
select count(pollID) from {prefix}_pollcomments where pollID=1
select lid, title from {prefix}_links_links order by date DESC limit 0,10
SELECT custom_title FROM {prefix}_modules WHERE title='Annoncen'
SELECT count(msg_id) FROM {prefix}_priv_msgs WHERE to_userid=2 AND read_msg=0
SELECT count(gid) FROM {prefix}_userguest WHERE touserid=2 AND touser = 'klaus' AND dummy=0
SELECT Count(ip) FROM {prefix}_visitors WHERE time>1318526455 AND uid=0;
SELECT COUNT(uid) FROM {prefix}_users WHERE (user_lastvisit >= 1318526455 AND user_stat=1 AND user_lastmod<>'logout')
SELECT bid, imageurl, alttext, script, imptotal, impmade FROM {prefix}_banner WHERE typ=1 AND active=1 ORDER BY RAND() LIMIT 1
SELECT bid, imageurl, alttext, script, imptotal, impmade FROM {prefix}_banner WHERE typ=2 AND active=1 ORDER BY RAND() LIMIT 1
SELECT bid, imageurl, alttext, script, imptotal, impmade FROM {prefix}_banner WHERE typ=7 AND active=1 ORDER BY RAND() LIMIT 1
SELECT bid, imageurl, alttext, script, imptotal, impmade FROM {prefix}_banner WHERE typ=6 AND active=1 ORDER BY RAND() LIMIT 1

[Webfan]

INSERT INTO {prefix}_annoncen_cats SET id_parent='0', name='klaus', beschreibung='klaus'

Gibt es auch eine Fehlermeldung dazu?

Du kannst in der Datei modules/Annoncen/action.cats.php nach

Code Auswählen Erweitern

sql_query($q);
einfügen:

Code Auswählen Erweitern

if(MX_IS_ADMIN)$html.=mysql_error();
Dann sollte Dir der Fehler angezeigt werden.

Ich rate mal, daß irgendwas mit der Kategorietabele nicht stimmt?
Das Problem gabs schonmal: http://www.pragmamx.org/Forum-topic-32765.html Vielleicht hilft der Link?

[klauspeter]

Danke War mal wieder super

der Artikel hat mir geholfen die Tabelle annoncen_cats fehlte

nun funzt es <nochmal daaanke!!!!