This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

Problems with StoryTeller 1.72 install


avatar
Fenis-Wolf 0
From: -
Problems with StoryTeller 1.72 install

Hello
I installed StoryTeller today, and I have been very impressed with the features.
I'm having a problem however. After the install, I can't get news to appear on the main page. The page looks correct, but in the center block, where news and the announcements should appear, all that shows is
Error: 1064 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 '' at line 1


If you'd like to see the error for yourself, check out  http://a2tech.us/cms/

Any ideas?

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic


1 Re: Problems with StoryTeller 1.72 install
avatar
OP 0
From: -
Problems with StoryTeller 1.72 install

That fixed it Smiling Face
Awesome. Its quite odd, the story table was full, and appeared to be correct.
But this is good, now I can get down to business, and write some news.
Thank you very much.
1 Re: Problems with StoryTeller 1.72 install
avatar
Administrator
1340
From: Vienna, Austria
Problems with StoryTeller 1.72 install

Very odd. Does the table esselbach_st_websites exists or is empty?

A quick workaround. Open index.php in an editor and find:
            $result = DBQuery("SELECT * FROM esselbach_st_stories WHERE story_main = '1' AND story_sticky = '0' AND story_hook = '0' AND story_time < ('$currentdate') ORDER BY story_time DESC LIMIT $blocks[website_newsmax]");


Replace $blocks[website_newsmax] with the number of headlines that you like display on the main page.

Here an example with 20 news:
            $result = DBQuery("SELECT * FROM esselbach_st_stories WHERE story_main = '1' AND story_sticky = '0' AND story_hook = '0' AND story_time < ('$currentdate') ORDER BY story_time DESC LIMIT 20");
1 Re: Problems with StoryTeller 1.72 install
avatar
OP 0
From: -
Problems with StoryTeller 1.72 install

I changed the max news entry to 20, and saved the page but it doesn't appear to change anything.
By the way, I really appreciate you answering my clients, especially since I'm not paying yet!
1 Re: Problems with StoryTeller 1.72 install
avatar
Administrator
1340
From: Vienna, Austria
Problems with StoryTeller 1.72 install

Originally posted by Fenis-Wolf:
I'm not going to paste it all here, but if you look at  http://a2tech.us/cms/ you'll see it.

Thanks, this helped a lot. Now turn off the debug mode again.

To fix this problem:
Other/websites => NEWS => Max. News => 20 (or any other value).

It seems like that the "Max. News" field is blank on your installation for some reason
1 Re: Problems with StoryTeller 1.72 install
avatar
OP 0
From: -
Problems with StoryTeller 1.72 install

If I disable the caching, the system still works, however I still don't have anything on the front page.

Now, after disabling caching, I made the changes to core.php as you suggested. Now, it appears debugging is on. I can no longer log into my admin control panel, but on the first page, I know get much, much more information. I'm not going to paste it all here, but if you look at  http://a2tech.us/cms/ you'll see it.
I'm stumped-its odvious something is wrong, but I'm not sure what could have caused it.
1 Re: Problems with StoryTeller 1.72 install
avatar
Administrator
1340
From: Vienna, Austria
Problems with StoryTeller 1.72 install

Is the site working with disabled caching system?

To disable the caching system:
Other/Config => Options => Using Cache => No
1 Re: Problems with StoryTeller 1.72 install
avatar
OP 0
From: -
Problems with StoryTeller 1.72 install

After some playing around, I found that by removing the line I could make the system work again, however I still couldn't see the debug option.
1 Re: Problems with StoryTeller 1.72 install
avatar
OP 0
From: -
Problems with StoryTeller 1.72 install

Adding that line causes the script to fail. This is what I have in the core.php
{
require("$ext/config.php");
$configs = explode(":_:", base64_decode($estc));
$configs[9]=1;
}


The script fails with:

Query: SELECT * FROM esselbach_st_users WHERE user_name = 'josh' AND user_admin = '1' (Time: 1098829323)
Query: SELECT * FROM esselbach_st_websites WHERE website_id = '1' (Time: 1098829323)
1 Re: Problems with StoryTeller 1.72 install
avatar
Administrator
1340
From: Vienna, Austria
Problems with StoryTeller 1.72 install

I forgot that this option is not available in the freeware control panel Hushed Face. In order to enable the debug mode in the freeware version, you need to change core.php in an editor.

Find the following line:
$configs = explode(":_:", base64_decode($estc));


and add after:
$configs[9]=1; // Enable debug mode


Reupload the updated core.php. Removing that line later will disable the debug mode again.
1 Re: Problems with StoryTeller 1.72 install
avatar
OP 0
From: -
Problems with StoryTeller 1.72 install

I don't see a 'Enable Debug Mode' option. This is all I can see:
 http://a2tech.us/options.jpg
1 Re: Problems with StoryTeller 1.72 install
avatar
Administrator
1340
From: Vienna, Austria
Problems with StoryTeller 1.72 install

I am not sure what this problem caused. Please activate the debug mode.

1) Backup your config.php
Download your current config.php. You need to reupload that file later to disable the debug mode

2) Enable the debug mode
In the admin control center: Other/Config => Options => Enable Debug Mode => Yes

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.