|
Stefan
Guest
|
 |
« Reply #25 on: August 11, 2005, 11:42:00 AM » |
|
Wouldn't it be much easier to run the install.php script under modules/pickle manually?
|
|
|
|
|
Logged
|
|
|
|
i2Paq
 Offline
Posts: 507
|
|
« Reply #26 on: August 11, 2005, 04:00:30 PM » |
|
Wouldn't it be much easier to run the install.php script under modules/pickle manually?
You mean modules/event? And how should I do that, It gives al kinds of errors. btw. everything seems to be working ok now, even the search |
|
|
|
« Last Edit: August 11, 2005, 04:07:04 PM by i2Paq »
|
Logged
|
Opensource is my life, but then elsewhere.
|
|
|
|
Stefan
Guest
|
|
« Reply #27 on: August 11, 2005, 04:36:07 PM » |
|
Yes, event, that's what I meant  After copying all the files manually if suffices to have the php script do the database actions. There is no safe-mode issue with this and I have tried it once with a couple of modules. However, if the install.php script creates files or folders, you would get errors. Strip everything out except database related stuff. But what I forgot to mention: if you don't want to take out its security feature (that not just any visitor can execute it) you need to call it out of WB directly, i.e. create a code section with a call to the script (include(WB_PATH.'/modules/event/install.php)  . |
|
|
|
« Last Edit: August 11, 2005, 04:38:58 PM by Stefan »
|
Logged
|
|
|
|
mightofnight
Offline
Posts: 153
|
|
« Reply #28 on: August 11, 2005, 07:08:04 PM » |
|
" settings 5 MyISAM latin1_swedish_ci 2.2 KB -" the latin1_sweedish_ci is something only to newer versions of SQL (i belive 4) they allow language specific stuff.. and when trying to input suhc a newer sql feature in an older version it just doens't work cause it's gets hung up on all thelanguage syntex.... how to solve.. using phpmyadmin go to export and you will find this option SQL export compatibility, it's a combo box.... select mysql 323... note this won't help the person trying to insall the mod but will help the person making the modde to make the queries mysql 3 compatiable |
|
|
|
« Last Edit: August 11, 2005, 07:09:48 PM by mightofnight »
|
Logged
|
-Travis
|
|
|
phil
Offline
Posts: 62
|
|
« Reply #29 on: August 30, 2005, 10:08:53 PM » |
|
I've found an problem in the Calendar Module.
If you look at the HTML Code a calendar page produces you can see that there are 2 <head> and 2 <body> elements.
In the display code of a module neither <body> nor <head> tags are allowed. The display code of a module is included into the <body> tag
|
|
|
|
|
Logged
|
|
|
|
ruebenwurzel
WebsiteBaker Org e.V.
Offline
Posts: 7660
|
|
« Reply #30 on: September 09, 2005, 11:28:25 PM » |
|
There is a little update for the event-calender. Please read here. |
|
|
|
|
Logged
|
|
|
|
Bennie_wijs
Offline
Posts: 230
|
|
« Reply #31 on: September 12, 2005, 02:20:31 PM » |
|
I've found an problem in the Calendar Module.
If you look at the HTML Code a calendar page produces you can see that there are 2 <head> and 2 <body> elements.
In the display code of a module neither <body> nor <head> tags are allowed. The display code of a module is included into the <body> tag
I have removed the 2 <head> and <body> tags. There is a little update for the event-calender. Please read here. Added this update to the zip in the Completed Modules list. |
|
|
|
|
Logged
|
I believe what I want to Believe
|
|
|
|
timur
Guest
|
|
« Reply #32 on: September 14, 2005, 05:20:06 PM » |
|
Does anyone have a piece of code to show events for the next week rather than the next month ?? Sorry, am not a php programmer, but like the calendar and want to use it  Many thanks. Timur |
|
|
|
|
Logged
|
|
|
|
Bennie_wijs
Offline
Posts: 230
|
|
« Reply #33 on: September 24, 2005, 05:39:21 PM » |
|
This code displays the next 5 days. You can make a section page and select module code and past this in. Only have 1 problem. inside the code I give up the page and section id of the event page to get the data. Do not know how to get this info a other way. You can properly paste this code inside your template ( have not tested that ) aswell $page_id = 8;
$section_id= 8;
require(WB_PATH.'/modules/event/language.php');
$query_content = $database->query("SELECT * FROM
".TABLE_PREFIX."mod_event_settings WHERE section_id = '$section_id'");
if($query_content->numRows() > 0) {
$fetch_content = $query_content->fetchRow();
$date_view = $fetch_content['date_view'];
}
$today = date("Y-m-j");
$month = date("m");
$day = date("j");
$year = date("Y");
$theday = mktime (0,0,0,$month ,$day+6 ,$year);
$lastday=date("Y-m-d",$theday);
echo "<center>";
echo " ----- Listing Next 5 days of Events + Events Today ----- <BR>";
$query_dates = $database->query("SELECT * FROM
`".TABLE_PREFIX."mod_event_dates` WHERE section_id = '$section_id' && date
>= '$today' && date < '$lastday' order by date");
while($result = $query_dates->fetchRow()) {
 $alt2date=$result['date'];
 if ($date_view == 1 ) {
  list($a2year, $a2month, $a2day) = split('[/.-]', $alt2date);
  $altdate=$a2day."-".$a2month."-".$a2year;
 } elseif ($date_view == 2 ) {
  list($a2year, $a2month, $a2day) = split('[/.-]', $alt2date);
  $altdate=$a2month."-".$a2day."-".$a2year;
 } else { $altdate=$alt2date; }
  echo $altdate." Event: ".$result['event_desc']."<BR>";
}
echo "</center>";
|
|
|
|
|
Logged
|
I believe what I want to Believe
|
|
|
i2Paq
Offline
Posts: 507
|
|
« Reply #34 on: October 24, 2005, 03:54:33 PM » |
|
Bennie_wijs, because I'm updating my test-site's and therfore starting to use the modules to see how the work I find something anoying in the Event Calendar. In the setting you can Display today's event Display all event's The problem I have with this is that it not only display's upcomming events but also events in the past. Furthermore when I actualy only want to display the today's event's and the events for this mont, not for next month or next year. Is this something for an update? Thanks! |
|
|
|
|
Logged
|
Opensource is my life, but then elsewhere.
|
|
|
Bennie_wijs
Offline
Posts: 230
|
|
« Reply #35 on: October 24, 2005, 04:02:50 PM » |
|
Well, the problem is simple.
The option Display all events I made for debuging not for standard showing.
(It just dumps all the events that are there in the database)
But people wanted it to stay in the module so I let it in.
But is you only want to display Today and this month. turn Display all events off.
|
|
|
|
« Last Edit: October 24, 2005, 04:06:22 PM by Bennie_wijs »
|
Logged
|
I believe what I want to Believe
|
|
|
i2Paq
Offline
Posts: 507
|
|
« Reply #36 on: October 24, 2005, 04:10:55 PM » |
|
Well, the problem is simple.
The option Display all events I made for debuging not for standard showing.
(It just dumps all the events that are there in the database)
But people wanted it to stay in the module so I let it in.
But is you only want to display Today and this month. turn Display all events off.
OK, duidelijk |
|
|
|
|
Logged
|
Opensource is my life, but then elsewhere.
|
|
|
|
Woudloper
Guest
|
|
« Reply #37 on: October 25, 2005, 10:16:20 PM » |
|
I think I found the problem ( which has mentioned somewhere else on the forum) regarding the search errors. It seems to be it has to do with the 'event' module. As you can see in the 'install.php' file the following is used for the query body: $query_body_code = " [TP]pages.page_id = [TP]mod_event_settings. page_id AND [TP]mod_event_settings. galtitle - \'[W][STRING][W]\' AND [TP]pages.searching = \'1\'
OR [TP]pages.page_id = [TP]mod_event_settings. page_id AND [TP]mod_event_settings. adminname - \'[W][STRING][W]\' AND [TP]pages.searching = \'1\'";
When you look at the other section in the 'install.php' ( where the tables are being created for this module) you will notice that the galtitle column isn't part of the mod_event_settings table. If you ask me this will result in a database query error since the column for this table does not exist. Maybe this can be fixed in a new version of the event module? |
|
|
|
« Last Edit: October 25, 2005, 10:26:14 PM by Woudloper »
|
Logged
|
|
|
|
ruebenwurzel
WebsiteBaker Org e.V.
Offline
Posts: 7660
|
|
« Reply #38 on: October 25, 2005, 10:24:36 PM » |
|
now its clear .galtitle is a table from pickle gallery. Thats why i thought pickle gallery is the modul with the problems. try to make an update for the install.php Thanks Matthias |
|
|
|
|
Logged
|
|
|
|
|
Woudloper
Guest
|
|
« Reply #39 on: October 25, 2005, 10:31:57 PM » |
|
.galtitle is a table from pickle gallery. Thats why i thought pickle gallery is the modul with the problems.
try to make an update for the install.php I think you mean the 'galtitle is a column for the pickle gallery module Furthermore I think the problem about this lies in the 'Hello World' module since this does not explain the 'query_start', 'query_body' and 'query_end' and as you can see in that module it is using the ' galtitle' in the 'query_body'. |
|
|
|
|
Logged
|
|
|
|
ruebenwurzel
WebsiteBaker Org e.V.
Offline
Posts: 7660
|
|
« Reply #40 on: October 25, 2005, 11:46:53 PM » |
|
ok,
here are a few little scripts to easily solve search error problems with the event-calendar. In the attached zip file there are thre scripts. Please unzip and copy the files to modules/event in your WB installation overwrite existing files.
install.php - you only need this for a new install
repair_event_search .php - run this script to repair an existing event-calendar installation
delete_event_search .php - this script deletes all entries from event-calendar modul in search table.
Hope all works, haven't tested it much
Matthias
[attachment deleted because of being too old]
|
|
|
|
« Last Edit: October 28, 2005, 02:57:08 PM by ruebenwurzel »
|
Logged
|
|
|
|
Hans
Offline
Posts: 560
|
|
« Reply #41 on: October 26, 2005, 12:37:08 PM » |
|
Hi Matthias, thank you. Will these and the ones for Pickle (your other post today) be added to the modules in Completed Modules?
Hans
|
|
|
|
|
Logged
|
Hans - Nijmegen - The Netherlands
|
|
|
ruebenwurzel
WebsiteBaker Org e.V.
Offline
Posts: 7660
|
|
« Reply #42 on: October 26, 2005, 01:34:41 PM » |
|
Hello Hans,
I sent a PM to Bennie_wijs, hope he have a look at the module code from Pickle and Event Calendar and if the changes are ok i hope he added them to completed Modules.
Matthias
|
|
|
|
|
Logged
|
|
|
|
i2Paq
Offline
Posts: 507
|
|
« Reply #43 on: October 26, 2005, 09:05:24 PM » |
|
After running the repair the error is still there.
|
|
|
|
|
Logged
|
Opensource is my life, but then elsewhere.
|
|
|
|
Woudloper
Guest
|
|
« Reply #44 on: October 26, 2005, 10:44:39 PM » |
|
After running the repair the error is still there.
Since your problem now is still related to the other thread (in the help) I have posted some comment over there... |
|
|
|
|
Logged
|
|
|
|
|
Woudloper
Guest
|
|
« Reply #45 on: October 28, 2005, 08:21:48 AM » |
|
install.php - you only need this for a new install Are you sure this newly 'install.php' is correct? When I view the source I see the following which might cause the problem i2Paq is having with the 'search'. As you can see the following is shown in the 'search_body' for the event module: [TP]pages.page_id = [TP]mod_event_settings. page_id AND [TP]mod_event_dates. date - \'[W][STRING][W]\' AND [TP]pages.searching = \'1\' OR
In the above line you make it possible to search for the ' date' column, but when you are searching you are searching with a string. Shouldn't the 'search_body' only contain VARCHAR fields and TEXT fields? |
|
|
|
|
Logged
|
|
|
|
ruebenwurzel
WebsiteBaker Org e.V.
Offline
Posts: 7660
|
|
« Reply #46 on: October 28, 2005, 10:23:14 AM » |
|
ooops,
seems that i have had tested it a little bit more. Try it later when I'm at home. And if this causes the error, i change the scripts.
Thanks for this tip
Matthias
|
|
|
|
|
Logged
|
|
|
|
Bennie_wijs
Offline
Posts: 230
|
|
« Reply #47 on: October 28, 2005, 11:31:48 AM » |
|
ruebenwurzel, I will wait till you are done testing before updating the module |
|
|
|
|
Logged
|
I believe what I want to Believe
|
|
|
ruebenwurzel
WebsiteBaker Org e.V.
Offline
Posts: 7660
|
|
« Reply #48 on: October 28, 2005, 03:06:20 PM » |
|
This is curious, after playing a little bit around with the search from event-calendar i found the solution. Search in Eventcalendar should now work if you uses the files from here. @Bennie Wijs I found a earlier version of the install.php from you where the search entries are 100% ok. In the aktually Version you can download at completed modules seems to be an older version of install.php. So could you please have a look to all files from Event Calendar (Maybe there ar some other older files, because i have problems do edit events) and then please upload an actually Version at Completed Modules. Matthias |
|
|
|
|
Logged
|
|
|
|
Bennie_wijs
Offline
Posts: 230
|
|
« Reply #49 on: October 31, 2005, 02:53:28 PM » |
|
@Bennie Wijs
I found a earlier version of the install.php from you where the search entries are 100% ok. In the aktually Version you can download at completed modules seems to be an older version of install.php. So could you please have a look to all files from Event Calendar (Maybe there ar some other older files, because i have problems do edit events) and then please upload an actually Version at Completed Modules.
Matthias
Oke, I will. |
|
|
|
|
Logged
|
I believe what I want to Believe
|
|
|
|
WebsiteBaker Community Forum
