Forum : eXV2 Module

Titel : PHP Warning bei Tutorials

Lofing : 20.10.2003 16:03  Hallo! Ich bin noch nicht so gut in PHP - Wenn ich bei mir in Tutorials gehe, sehe ich das: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in ...htdocs/www/exoops/class/database/mysql.php on line 145 Was heißt das eigentlich? Sollte ich das modul vielleicht neu hochladen und installieren?

Nobse : 20.10.2003 19:42  Ich finde den Fehler momentan nicht Ist aber nicht weiter tragisch diese Warnung es funktionert alles. Musst nur den Debugmodus ausschalten.

Gast : 15.12.2003 12:57  I got the same warning on my test site. Going to dig in the code on that one, need to figure out the problem. Using E-Xoops 1.06 CVS during the test and full debug mode.

Nobse : 15.12.2003 20:52  So habe jetzt den Fehler gefunden. Liegt in der xoopstree classe in der function function loadtree($title='title') { global $db, $myts; $sql = 'SELECT '.$this->pid.', '.$this->cid.', '.$title.' FROM '.$this->table.''; $result = $db->query($sql); while (list($pid, $cid, $name) = $db->fetch_array($result)) { $this->pidcid[$pid][$cid] = $myts->makeTboxData4Show($name); $this->cidpid[$cid][$pid] = $myts->makeTboxData4Show($name); } } hier wird $title fest auf title gelegt. Das bedeutet das in der Tabelle für die Kategorien das Feld für den Namen title heissen muss !! Entweder ich muss das ganze Modul ändern oder Debug ausschalten.

Gast : 15.12.2003 23:23  If you have the time for complete debug it would be nice, because it's a very nice module to use for tutorials. But as you said it could mean re-write of the whole module code, on the other hand, wouldn't it be great to have a completely functioning module to give to the E-Xoops community which is growing in numbers each day. Would it be possible to use the configuration manager part from i.e. news or the sections. Then combine it with the existing Tutorials v2.1b make it a new module with the tables manager from 2.1b. I have a lot of ideas to improve it, but not much experince php programming just yet.

Nobse : 16.12.2003 21:07  test this version old version deinstallieren !!

Gast : 16.12.2003 21:42  Ok, now the tutorials mod works in a way. But there's still errors in the image upload function. Maybe i'm too picky, but i like a working module. Got this error in the admin/modify category, since the image upload doesn't work. Modify category Error Number: 2 [Warning] Error Message: getimagesize(): Read error! In File: E:\Web\root\private\mods\modules\tutorials\admin\index.php On Line: 202 I had to try without images, since they didn't work in the first place. E-Xoops has this built in. I could take a look at it myself. Couldn't it use the image library from E-Xoops core. This would make it easier to deal with image upload. I read about this module and it's compability at modscentral.com.

Nobse : 17.12.2003 20:27  open admin/index.php insert line 196 if ($imgpath != "") { and line 206 } [ Geändert von Nobse an 17.12.2003 20:32 ]

Gast : 17.12.2003 20:43  Thank you Nobse, that did fix the problem. Now it's working like a dream. It is a great module.

Nobse : 17.12.2003 20:49  Module is not of me I hav converted for e-xoops