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.  / News module 1.2
Register
1
Kriegerman
News module 1.2

  • 2004/11/16 2:10

  • 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 module 1.2

  • 2004/11/16 2:11

  • davidl2

  • XOOPS is my life!

  • Posts: 4843

  • Since: 2003/5/26


You only needed to post it once :)
3
Kriegerman
Re: News module 1.2

  • 2004/11/16 2:14

  • Kriegerman

  • Just popping in

  • Posts: 35

  • Since: 2004/10/25


Sorry I tough that putting my question in multiple categories would make it more accessable.

Sorry,

Any answer for me
4
tjnemez
Re: News module 1.2

  • 2004/11/16 2:14

  • tjnemez

  • Home away from home

  • Posts: 1594

  • Since: 2003/9/21


you do not need to know how to create a table as module install creates table for you. your error is odd, not sure what is up with that. if you are just installing i would uninstall and do a fresh install.

i just installed this module with no problem.

edit: oops, just realized another thread is happening, please disregard my post.
5
davidl2
Re: News module 1.2

  • 2004/11/16 2:17

  • davidl2

  • XOOPS is my life!

  • Posts: 4843

  • Since: 2003/5/26


Quote:

Kriegerman wrote:
Sorry I tough that putting my question in multiple categories would make it more accessable.

Sorry,

Any answer for me


Unfortunately it means that 2 sets of people end up answering the same question :)

the other one is over here - if anyone is able to assist with the problem :)
6
Kriegerman
Re: News module 1.2

  • 2004/11/16 2:40

  • Kriegerman

  • Just popping in

  • Posts: 35

  • Since: 2004/10/25


So what should I de-install to make sure everithing is ok to re-install!
7
Kriegerman
Re: News module 1.2

  • 2004/11/16 2:44

  • Kriegerman

  • Just popping in

  • Posts: 35

  • Since: 2004/10/25


I'm also having this message at the bottom of my page when I try to Install.

Notice [PHP]: Use of undefined constant _MI_NEWS_BNAME6 - assumed '_MI_NEWS_BNAME6' in file modules/news/xoops_version.php line 47
8
Kriegerman
Re: News module 1.2

  • 2004/11/16 2:46

  • Kriegerman

  • Just popping in

  • Posts: 35

  • Since: 2004/10/25


So here are my error message in a nutshell,Under INSTALLING ARTICLE:

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

and at the bottom of my page:

Notice [PHP]: Use of undefined constant _MI_NEWS_BNAME6 - assumed '_MI_NEWS_BNAME6' in file modules/news/xoops_version.php line 47
9
brash
Re: News module 1.2

  • 2004/11/16 2:56

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


The second error is just concerning an undefined constant, so nothing to worry about too much. The first error has me a little puzzled though. Can you turn on the MySQL debug block and post back the error it generates?
10
Kriegerman
Re: News module 1.2

  • 2004/11/16 15:59

  • Kriegerman

  • Just popping in

  • Posts: 35

  • Since: 2004/10/25


News wont install so where can I debug the database MySQL if there's no entry for the news module?
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

338 user(s) are online (244 user(s) are browsing Support Forums)

Members: 0

Guests: 338

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