A Few Problems

[Obey]

Hey Devbest,

Recently I opened a new hotel. It's R63B, PlusEMU and VerseCMS. There's a few problems that need to be fixed and then everything will be good. First one:

At the top, it says Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\app\tpl\class.forms.php on line 87
If I need to post any of the files, tell me and I will do so. Next problem:

This one is even more annoying.

I have one more and this is the most urgent I think. I am the only person that can access the client. The hotel is currently on hamachi until we get a VPS. They get onto the me page and then when they try to get onto the client it takes them to Verse Hotel voting API which when they vote, they go to verse client (the hotel is down so its 404.)

Please anyone help me, thanks!

 

[Mexicano]

For the comments to work run this sql:
HTML:
-- ----------------------------
-- Table structure for `cms_comments`
-- ----------------------------
DROP TABLE IF EXISTS `cms_comments`;
CREATE TABLE `cms_comments` (
`id` int(6) NOT NULL AUTO_INCREMENT,
`story` int(6) DEFAULT NULL,
`comment` text NOT NULL,
`date` int(10) DEFAULT NULL,
`author` varchar(999) NOT NULL,
`article` int(9) NOT NULL,
`userid` int(11) NOT NULL,
`posted_on` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8;

 

[Obey]

For the comments to work run this sql:
HTML:
-- ----------------------------
-- Table structure for `cms_comments`
-- ----------------------------
DROP TABLE IF EXISTS `cms_comments`;
CREATE TABLE `cms_comments` (
`id` int(6) NOT NULL AUTO_INCREMENT,
`story` int(6) DEFAULT NULL,
`comment` text NOT NULL,
`date` int(10) DEFAULT NULL,
`author` varchar(999) NOT NULL,
`article` int(9) NOT NULL,
`userid` int(11) NOT NULL,
`posted_on` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8;

Navicat or Phpmyadmin?

 

[Heisenberg]

Navicat or Phpmyadmin?

Both ones will work.

 

[Nehalem]

Navicat or Phpmyadmin?

Doesn't really matter.

Could you show me the line of the first error?

 

[Obey]

Doesn't really matter.

Could you show me the line of the first error?

You mean in my folders?

 

[Nehalem]

You mean in my folders?

Line 87 in class.forms.php.

 

[Obey]

Line 87 in class.forms.php.

You must be registered for see links

 

[Nehalem]

You must be registered for see links

Show me the whole file instead (upload it on pastebin).

But the query did probably fail.

 

[Obey]

You must be registered for see links

[/URL]

 

[Nehalem]

Do you have the "title, id, published, shortstory, image" columns in your cms_news?

Otherwise you could add a few lines that would check if the query failed.

 

[Obey]

Do you have the "title, id, published, shortstory, image" columns in your cms_news?

Otherwise you could add a few lines that would check if the query failed.

I just searched cms_news in my Phpmyadmin and there was no results.

 

[Nehalem]

I just searched cms_news in my Phpmyadmin and there was no results.

PM me instead and I will try to help you. No need to spam this thread.