Kayako Logo
Developers & Code Interested in customizing your Kayako products? Discuss modifications and develop your own mods with the community.

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  (#16) Old
Sheep Offline
Member
 
Sheep's Avatar
 
Posts: 326
Join Date: Feb 2007
Location: Lyon, France

SupportSuite
Owned License
27-06-2007, 02:54 PM

Many thanks to you, that was a very good start. I don't think i would have been able to start without your guide (or that would have been so much work). Thanks again


Antoine "Sheep" BERMON
-- I left kayako's community: do NOT contact me for job offers, thx --
   
Reply With Quote
  (#17) Old
richm Offline
Member
 
richm's Avatar
 
Posts: 387
Join Date: Jan 2007
Location: Orange County, CA

05-07-2007, 07:05 PM

Trying this out, and at step 8, when I click install, I get the following:

Module: helloworld (Page 1 of 1)
Creating table helloworld: FAILED
Reason: Key column 'board_id' doesn't exist in table
Inserting data into settings: (# Of Queries: 1) FAILED

MySQL 5.0.27
PHP Version 5.2.1
Build 3.10.2
Server: Win2003

Any ideas what I might have done wrong here?

Thanks,

Rich


--
Features I need asap:
1) Ticket search in the client portal!
2) Column display in client portal showing clients email address or name
3) Downloads by client
(i.e. - each client has their own download area and can't see/touch downloads for any other client.) This would be on top of a "public" download area.
4) Integrated KB image uploads
The ability for staff to upload images with a KB articles.
Cheers!

Last edited by richm : 05-07-2007 at 07:30 PM.
   
Reply With Quote
  (#18) Old
craigbrass Offline
Senior Member
 
Posts: 4,951
Join Date: Jun 2005
Location: Cumbria, UK

SupportSuite
Owned License
05-07-2007, 07:10 PM

Hmm, shame it didn't show you anything more than just "FAILED". Maybe something to look into for future versions?


Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member)

Icon Headquarters - Its Elixir - Web2Messenger
   
Reply With Quote
  (#19) Old
Sheep Offline
Member
 
Sheep's Avatar
 
Posts: 326
Join Date: Feb 2007
Location: Lyon, France

SupportSuite
Owned License
05-07-2007, 07:27 PM

Shame on me

Quote:
$_SWIFT["query"]["create"]["helloworld"]="CREATE TABLE ".TABLE_PREFIX."helloworld (
helloworld_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
helloworld_text VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (board_id)
);"
I forgot that i changed it to get it work. That was a little mistake in greengiant guide.

in the step 3 : replace the board_id with helloworld_id .
Quote:
$_SWIFT["query"]["create"]["helloworld"]="CREATE TABLE ".TABLE_PREFIX."helloworld (
helloworld_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
helloworld_text VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (helloworld_id)
);"

Craigbass: This is an SQL error, so no additional informations can be displayed. There's nothing that can be improved as it's not Kayako's fault.

Anyway this creation query is just there to show you that you can create extra informations (like a new table for YOUR mod for exemple), so you can DELETE this part if you don't need it.


Guide updated, thx rich


Antoine "Sheep" BERMON
-- I left kayako's community: do NOT contact me for job offers, thx --

Last edited by Sheep : 05-07-2007 at 08:50 PM.
   
Reply With Quote
  (#20) Old
richm Offline
Member
 
richm's Avatar
 
Posts: 387
Join Date: Jan 2007
Location: Orange County, CA

05-07-2007, 07:42 PM

Thanks Antoine! Works now!

Pressing on with the rest.

Appreciate you taking the time to reply!

Rich


--
Features I need asap:
1) Ticket search in the client portal!
2) Column display in client portal showing clients email address or name
3) Downloads by client
(i.e. - each client has their own download area and can't see/touch downloads for any other client.) This would be on top of a "public" download area.
4) Integrated KB image uploads
The ability for staff to upload images with a KB articles.
Cheers!
   
Reply With Quote
  (#21) Old
Hawkwing Offline
Member
 
Posts: 98
Join Date: Oct 2005

Help! - 13-07-2007, 11:08 AM

I have followed the tutorial step by step.
The links are there and the widget but when I click I only get a blank page.
What am I missing.

I have copied the code and not altered anything to test it out but there is nothing shown.

Please, help me out...

I'm testing on 3.10.02 CVS from june 14.
   
Reply With Quote
  (#22) Old
Sheep Offline
Member
 
Sheep's Avatar
 
Posts: 326
Join Date: Feb 2007
Location: Lyon, France

SupportSuite
Owned License
13-07-2007, 11:50 AM

are you talking about the client side widget? Is the staff part working?

Edit: ah, you're coming from Flash Tutorial Section
The problem might come from missing includes in the external file (when not using the page as a part of the module but as an external page using supporsuite template).
PHP Code:
require_once ("./includes/functions_template.php"); 
add this at the beggining just after the swift.php include.

If you want advanced debug infos:
insert
PHP Code:
error_reporting(E_ALL); 
just after the swift.php include.


Antoine "Sheep" BERMON
-- I left kayako's community: do NOT contact me for job offers, thx --

Last edited by Sheep : 13-07-2007 at 11:56 AM.
   
Reply With Quote
  (#23) Old
Hawkwing Offline
Member
 
Posts: 98
Join Date: Oct 2005

13-07-2007, 12:24 PM

Quote:
Originally Posted by Sheep View Post
are you talking about the client side widget? Is the staff part working?

Edit: ah, you're coming from Flash Tutorial Section
The problem might come from missing includes in the external file (when not using the page as a part of the module but as an external page using supporsuite template).
PHP Code:
require_once ("./includes/functions_template.php"); 
add this at the beggining just after the swift.php include.

If you want advanced debug infos:
insert
PHP Code:
error_reporting(E_ALL); 
just after the swift.php include.
I have no external file. I have done helloworld1.php and...2. When I click the link in staff it presents a blank page and when I click the widgetlink its the same.
   
Reply With Quote
  (#24) Old
Sheep Offline
Member
 
Sheep's Avatar
 
Posts: 326
Join Date: Feb 2007
Location: Lyon, France

SupportSuite
Owned License
13-07-2007, 12:28 PM

ok, lets debug the problem

PHP Code:
 function _eventcallback($eventtype$eventaction)

after this add:
PHP Code:
 error_reporting(E_ALL);
echo 
$eventtype." EVENT ".$eventaction


Antoine "Sheep" BERMON
-- I left kayako's community: do NOT contact me for job offers, thx --

Last edited by Sheep : 13-07-2007 at 12:30 PM.
   
Reply With Quote
  (#25) Old
Hawkwing Offline
Member
 
Posts: 98
Join Date: Oct 2005

13-07-2007, 12:35 PM

Quote:
Originally Posted by Sheep View Post
ok, lets debug the problem

PHP Code:
 function _eventcallback($eventtype$eventaction)

after this add:
PHP Code:
 error_reporting(E_ALL);
echo 
$eventtype." EVENT ".$eventaction
I added the code in "helloworld.php" but it still presents a blank page when clicking the link in staff.
   
Reply With Quote
  (#26) Old
Sheep Offline
Member
 
Sheep's Avatar
 
Posts: 326
Join Date: Feb 2007
Location: Lyon, France

SupportSuite
Owned License
13-07-2007, 12:37 PM

What's the link of the page?
should be index.php?_m=helloworld&_a=hello1


Antoine "Sheep" BERMON
-- I left kayako's community: do NOT contact me for job offers, thx --
   
Reply With Quote
  (#27) Old
Hawkwing Offline
Member
 
Posts: 98
Join Date: Oct 2005

13-07-2007, 12:40 PM

Quote:
Originally Posted by Sheep View Post
What's the link of the page?
should be index.php?_m=helloworld&_a=hello1
The code is the same. I'll add the picture on where it goes wrong.
Attached Images
File Type: gif staffpanel.gif (77.6 KB, 44 views)
   
Reply With Quote
  (#28) Old
Sheep Offline
Member
 
Sheep's Avatar
 
Posts: 326
Join Date: Feb 2007
Location: Lyon, France

SupportSuite
Owned License
13-07-2007, 12:53 PM

The strange thing is that it seems like there's no callback on the module :\

If you know php a bit, try to put some echo "checkpoint(1)"; around in the code to know where it stops.

Atm i really have no ideas on where the error is


Antoine "Sheep" BERMON
-- I left kayako's community: do NOT contact me for job offers, thx --
   
Reply With Quote
  (#29) Old
Sheep Offline
Member
 
Sheep's Avatar
 
Posts: 326
Join Date: Feb 2007
Location: Lyon, France

SupportSuite
Owned License
13-07-2007, 12:57 PM

Ah maybe the error is before...

try to put error_reporting(E_ALL); in index.php just after the swift include

don't get crazy with all the notice errors, try to look for a FATAL one


Antoine "Sheep" BERMON
-- I left kayako's community: do NOT contact me for job offers, thx --
   
Reply With Quote
  (#30) Old
phpimpact Offline
New Member
 
Posts: 10
Join Date: Jul 2007

Owned License
19-07-2007, 02:55 PM

And once you are done you can kill your self right? joke

Very nice tutorial, they really should add stuff like that to the manual!
   
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0

Kayako provides online help desk software and support solutions; enabling companies to improve their support and reduce costs.

Our three main products include: SupportSuite, eSupport and LiveResponse



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46