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 Community Support forums / 
  3. Beginner's Corner 
  4.  / trouble installing new modules
Register
1
sealdeal
trouble installing new modules

  • 2012/6/21 9:57

  • sealdeal

  • Just popping in

  • Posts: 72

  • Since: 2010/1/11


I'm using hostgator server when I try and install marquee module I get this

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 19

any help on how to fix this problem?


XOOPS Version XOOPS 2.5.4
PHP Version 5.2.17
mySQL Version 5.5.23-55
Server API cgi-fcgi
OS Linux
safe_mode Off
register_globals On
magic_quotes_gpc Off
allow_url_fopen On
fsockopen On
post_max_size 64M
max_input_time 60
output_buffering
max_execution_time 30
memory_limit 256M
file_uploads On
upload_max_filesize 64M
2
iHackCode
Re: trouble installing new modules

they keyword TYPE is no longer supported in the newer versions of mysql (i believe 5.2) and it was replaced with ENGINE.

ENGINE=MyISAM AUTO_INCREMENT=1

it should be in the file in the module's folder/sql/mysql.sql (but it could be named something else or in a different folder, that is what people usually name it if they follow convention

where is the download of this marquee module we'll get a dev to modify it.
CBB / LatestNews / Publisher / XM-Spotlight

(ﾉ◕ヮ◕)ﾉ*:･ﾟ✧
3
Dante7237
Re: trouble installing new modules

  • 2012/6/21 14:07

  • Dante7237

  • Friend of XOOPS

  • Posts: 294

  • Since: 2008/5/28


As much as I love hostgator, they are usually a bit behind in versions that are installable via the cPanel.

Manual installation is a fairly easy task that you shouldn't have too much trouble with. And you get the latest versions that way.

Hint* Lower your memory limit to match the max filesize.
The more I know, the more I know that I really didn't wanna know.
4
iHackCode
Re: trouble installing new modules

Yeah i know. PHP 5.2 end of life was over a year ago

Quoting Rasmus.

"If you're not on (PHP) 5.3 what the hell are you doing?" -rasmus
CBB / LatestNews / Publisher / XM-Spotlight

(ﾉ◕ヮ◕)ﾉ*:･ﾟ✧
5
sealdeal
Re: trouble installing new modules

  • 2012/6/21 17:18

  • sealdeal

  • Just popping in

  • Posts: 72

  • Since: 2010/1/11


Thanks that was the ticket to fix my problem, now I need to try and get them to up sql to 5.3
6
sealdeal
Re: trouble installing new modules

  • 2012/6/21 17:23

  • sealdeal

  • Just popping in

  • Posts: 72

  • Since: 2010/1/11


Where would I lower my memory limit to match file size?
yea I know just enough to be dangerous to my website, but that’s how I learn.
7
Dante7237
Re: trouble installing new modules

  • 2012/6/21 19:13

  • Dante7237

  • Friend of XOOPS

  • Posts: 294

  • Since: 2008/5/28


1 level above your public_html folder look for php.ini

Its not about "matching" the size, but in your case it should match.
The more I know, the more I know that I really didn't wanna know.
8
Dante7237
Re: trouble installing new modules

  • 2012/6/21 19:14

  • Dante7237

  • Friend of XOOPS

  • Posts: 294

  • Since: 2008/5/28


Edit these values to "Off" in the same file:
register_globals On
allow_url_fopen On
The more I know, the more I know that I really didn't wanna know.
9
sealdeal
Re: trouble installing new modules

  • 2012/6/22 12:19

  • sealdeal

  • Just popping in

  • Posts: 72

  • Since: 2010/1/11


another question where do I find sql file for altsys

Creating tables...You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7

Thanks again
10
Mamba
Re: trouble installing new modules

  • 2012/6/22 12:42

  • Mamba

  • Moderator

  • Posts: 11366

  • Since: 2004/4/23


in the /sql directory, which is located in:

/xoops_lib/libs/altsys/sql
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

166 user(s) are online (130 user(s) are browsing Support Forums)

Members: 0

Guests: 166

more...

Donat-O-Meter

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

Latest GitHub Commits