XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module requests 
  4.  / xoops chat integration (like facebook) ?
Register
131
Mazarin
Re: xoops chat integration (like facebook) ?

  • 2010/4/8 20:37

  • Mazarin

  • Just can't stay away

  • Posts: 533

  • Since: 2008/12/10


I ended up making both tables InnoDB to get rid of the charset and auto increment. That was the only way to get it to work on this specific version (4.12 I believe) of MySQL.
132
Dante7237
Re: xoops chat integration (like facebook) ?

  • 2010/4/10 17:23

  • Dante7237

  • Friend of XOOPS

  • Posts: 296

  • Since: 2008/5/28


Has this module been finalized yet? And if so, why isn't in the module listing here?

Anxious to see this work. I have the only set I could find (from source forge) and will give it a shot this weekend.
133
culex
Re: xoops chat integration (like facebook) ?

  • 2010/4/10 18:54

  • culex

  • Module Developer

  • Posts: 711

  • Since: 2004/9/23


The module is still in pre 1.0 state, hopefully soon (1-2 weeks) to be released as 1.0 official release.

At the moment it's being tested and some final small bugs and twitches are being elliminated.

It's (so far) fully functional and running as it's supposed, but some changes can still be added in the svn trunk prior official release, so you'll have to keep an eye on this thread before this to keep the module updated.

Until then you can test from here.
http://xoops.svn.sourceforge.net/viewvc/xoops/XoopsModules/xim/trunk/

Just rename the downloaded folder trunk -> xim
134
kris_fr
Re: xoops chat integration (like facebook) ?

  • 2010/4/10 20:01

  • kris_fr

  • Theme Designer

  • Posts: 1009

  • Since: 2005/12/31


hi,

Quote:
-- CREATE TABLE `xim_chat` ( `id` int(10) unsigned NOT NULL auto_increment, `from` mediumint(8) unsigned NOT NULL, `to` mediumint(8) unsigned NOT NULL, `message` text NOT NULL, `sent` datetime NOT NULL default '0000-00-00 00:00:00', `recd` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 Le fichier SQL n'est pas valide !


my config :
Version de XOOPS --> XOOPS 2.4.4
Version de PHP --> 5.3.2RC3
Version de mySQL --> 5.1.44-community
API serveur --> apache2handler
OS --> WINNT
safe_mode Off
register_globals Off
magic_quotes_gpc Off
allow_url_fopen On
fsockopen On
allow_call_time_pass_reference Off
post_max_size 10M
max_input_time 60
output_buffering 4096
max_execution_time 300
memory_limit 32M
file_uploads On
upload_max_filesize 10M
135
Dante7237
Re: xoops chat integration (like facebook) ?

  • 2010/4/10 20:13

  • Dante7237

  • Friend of XOOPS

  • Posts: 296

  • Since: 2008/5/28


Me too.. Same errors.

XOOPS Version XOOPS 2.4.4
PHP Version 5.2.13
mySQL Version 5.1.30
Server API cgi-fcgi
OS Linux
safe_mode Off
register_globals Off
magic_quotes_gpc Off
allow_url_fopen Off
fsockopen On
post_max_size 64M
max_input_time 60
output_buffering
max_execution_time 30
memory_limit 64M
file_uploads On
upload_max_filesize 64M

*edit*
Not exactly the same.. oops:
Quote:
Unable to install XIM. Error(s): Installing XIM -- CREATE TABLE `xim_chat` ( `id` int(10) unsigned NOT NULL auto_increment, `from` mediumint(8) unsigned NOT NULL, `to` mediumint(8) unsigned NOT NULL, `message` text NOT NULL, `sent` datetime NOT NULL default '0000-00-00 00:00:00', `recd` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 is not a valid SQL!
136
culex
Re: xoops chat integration (like facebook) ?

  • 2010/4/10 21:09

  • culex

  • Module Developer

  • Posts: 711

  • Since: 2004/9/23


Well some idiot (culex that is ..sorry guys ) was trying to make more MySQL 4x friendly and forgot to roll back.

I have now corrected my error back to rev 4683 wich was working...

I have updated the svn

or change sql file to this content instead

le="color: #000000"><?php CREATE TABLE `xim_chat` ( `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `from` mediumint(8) unsigned NOT NULL, `to` mediumint(8) unsigned NOT NULL, `message` TEXT NOT NULL, `sent` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `recd` INTEGER UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) )ENGINE = InnoDB; CREATE TABLE `xim_pers_conf` ( `id` int(1) unsigned NOT NULL auto_increment, `username` text NOT NULL, `sound` int(1) NOT NULL default '1', `status` int(1) NOT NULL default '2', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


I think we'll have to desite weather to use MyIsam or InnoDb but for now this works :)
137
Dante7237
Re: xoops chat integration (like facebook) ?

  • 2010/4/10 22:36

  • Dante7237

  • Friend of XOOPS

  • Posts: 296

  • Since: 2008/5/28


Here's the result (after replacing the sql file content):

Quote:
-- CREATE TABLE `xim_chat` ( `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `from` mediumint(8) unsigned NOT NULL, `to` mediumint(8) unsigned NOT NULL, `message` TEXT NOT NULL, `sent` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `recd` INTEGER UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) )ENGINE = InnoDB is not a valid SQL!



And I did clear the caches, before retrying..
138
culex
Re: xoops chat integration (like facebook) ?

  • 2010/4/11 1:57

  • culex

  • Module Developer

  • Posts: 711

  • Since: 2004/9/23


Think you need to clean also the comments in the sql file. I just checked to make sure and it gives ok install in my website...


Try downloading the and replacing all content in sql file with this...

http://xoops.svn.sourceforge.net/viewvc/xoops/XoopsModules/xim/trunk/sql/mysql.sql?revision=4702
139
kris_fr
Re: xoops chat integration (like facebook) ?

  • 2010/4/11 10:24

  • kris_fr

  • Theme Designer

  • Posts: 1009

  • Since: 2005/12/31


Nice fix culex

but little error with dobble define language (_MB_XIM_BLOCK) in language files

french translations (utf8 and iso) here --> http://xfr.svn.sourceforge.net/viewvc/xfr/language/modules/xim/0.3/modules/xim/language/
140
culex
Re: xoops chat integration (like facebook) ?

  • 2010/4/11 11:39

  • culex

  • Module Developer

  • Posts: 711

  • Since: 2004/9/23


Thank you Kris :) I have added your language files to svn both iso and utf-8 :)

I have also added Danish translation, dont really know why it was not there from the beginning

Fixed double define.: I think this one language define was intentional but now I cannot remember why I put there hehe... for now I removed so maybe it was there for no reason :) :) :)
« 1 ... 11 12 13 (14) 15 16 17 ... 28 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!

Latest GitHub Commits