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 troubleshooting 
  4.  / News 1.2 Troubles
Register
1
Kriegerman
News 1.2 Troubles

  • 2004/11/16 2:09

  • Kriegerman

  • Just popping in

  • Posts: 35

  • Since: 2004/10/25


Hi,

This is what i get when i try to install the news 1.2 module.

I do not know how to create table in SQL. Can somebody help.



You have an error in your SQL syntax near 'catname varchar(40) NOT NULL default '', PRIMARY KEY (storyid), KEY idxstor' at line 1

Thanks,
Kriegerman
2
davidl2
Re: News 1.2 Troubles

  • 2004/11/16 2:12

  • davidl2

  • XOOPS is my life!

  • Posts: 4843

  • Since: 2003/5/26


Which version of XOOPS are u using?
3
brash
Re: News 1.2 Troubles

  • 2004/11/16 2:12

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


Do you already have News 1.1 installed?
4
Kriegerman
Re: News 1.2 Troubles

  • 2004/11/16 2:16

  • Kriegerman

  • Just popping in

  • Posts: 35

  • Since: 2004/10/25


I had deleted it from my admin section and from my server, but I guess I did not do a good job!

I'm using XOOPS 2.0.7
5
davidl2
Re: News 1.2 Troubles

  • 2004/11/16 2:18

  • davidl2

  • XOOPS is my life!

  • Posts: 4843

  • Since: 2003/5/26


Did you delete it, or de-install it?
6
Kriegerman
Re: News 1.2 Troubles

  • 2004/11/16 2:22

  • Kriegerman

  • Just popping in

  • Posts: 35

  • Since: 2004/10/25


Well I had the default news 1.1 module and I de-installed it in the admon then I went to my server and de-install the news module.
7
brash
Re: News 1.2 Troubles

  • 2004/11/17 21:25

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


So you uninstalled News 1.1 using the XOOPS module admin control panel, and then deleted the physical files from your website?

You are getting n SQL syntax error, which doesn't make a great deal of sense since News 1.2 is used quite heavily. Regardless, to get to the next step if you could turn on your MySQL debug block from your XOOPS admin panel in general preferences, and then try running the script again. In the MySQL debug block you should see a list of all the MySQL commands, and somewhere in there one of them should be red which indicates your error. Copy ALL the red text and post it here.
8
Kriegerman
Re: News 1.2 Troubles

  • 2004/11/18 0:25

  • Kriegerman

  • Just popping in

  • Posts: 35

  • Since: 2004/10/25


I installed the version 1.2.1 and made sure to delete the version1 argument in the MySQL.sql file. Noe I can't get the perms workin. Need PHP help. I put my problem in the perms problem article of this topic.

Thanks
9
brash
Re: News 1.2 Troubles

  • 2004/11/18 1:05

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


You should NOT have to edit anything in the SQL file. News 1.2.1 is working in hundreds (more likely thousands) of XOOPS sites. Lets debug BEFORE we start editing anything. Have you got the MySQL debug error?
10
Kriegerman
Re: News 1.2 Troubles

  • 2004/11/18 1:46

  • Kriegerman

  • Just popping in

  • Posts: 35

  • Since: 2004/10/25


I have put my MySQL debugger and there was no errors showing. But when I put my PHP debugger that is when I get the error

Warning [PHP]: Invalid argument supplied for foreach() in file class/xoopsform/grouppermform.php line 255

thanks
Kriegerman
(1) 2 3 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

346 user(s) are online (238 user(s) are browsing Support Forums)

Members: 0

Guests: 346

more...

Donat-O-Meter

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

Latest GitHub Commits