phpSQLiteCMS Forum

adding a skyscraper to the template

Jan — Sat, 28 Aug 2010 20:54:30 +0200

Hey folks,
I love this CMS and I'm using it since an early 0.x version ;)
I must admit I'm not used to web-programming and I try to add a skyscraper to the left side with google ads and I have no clue how to do it. I tried to add the code to a global content block and now I try to find the right place to add the right code to the template file default.tpl

Thank you very much for ur help!

cheerio!

Error Message (reply)

Boazdexter — Fri, 20 Aug 2010 06:32:35 +0200

hye this is dexter
and i many time faced this error message so please kindly solve this problem

________________________
"Want to get-on Google's first page and loads of traffic to your website? Hire a SEO Specialist from Ocean Groups seo pecialist
"

How to post code (reply)

Boazdexter — Fri, 20 Aug 2010 06:30:21 +0200

hye there
i didnt know how to post code but when i read this forum ..i really knew so much about this

so thanks

_________________
"Want to get-on Google's first page and loads of traffic to your website? Hire a SEO Specialist from Ocean Groups seo pecialist
"

Error Message

sachage — Thu, 19 Aug 2010 15:40:09 +0200

Hello

Get the following error message. What should I do?

Warning: strftime() [function.strftime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Paris' for '2,0/DST' instead in C:\Programme\OSGeo
\MapGuide\Web\Apache2\htdocs\phpsqlitecms\cms\includes\classes\Localization.class.php on line 117

thanks!

Sacha

How to build a search engine in php and using mysql as datab

rileykathleen — Thu, 19 Aug 2010 09:22:38 +0200

firstly we are maintaining a database in mysql that will contain all information and the keywords. then we have to fetch the information from keywords using php code.please help us because we are the beginners.thanks ..

Upgrade to 2.0 (reply)

joetraff — Sat, 14 Aug 2010 08:15:50 +0200

Looking for the solution.
Please keep us posted.

block ip adress (reply)

joetraff — Sat, 14 Aug 2010 08:15:01 +0200

Very helpful reply about blocked IP.
Keep up the good work of sharing.

Upgrade to 2.0 (reply)

rotten77 — Fri, 13 Aug 2010 17:59:44 +0200

You have no installed SQlite DB. Just un-comment the "extension=php_pdo_sqlite.dll" in php.ini

Upgrade to 2.0 (reply)

Jan — Sat, 07 Aug 2010 12:14:29 +0200

Same problem here! Is it possible to easily upgrade? Never found any kind of statement regarding this topic!??

Contact. Don't send messages.

LamboR — Sat, 31 Jul 2010 13:37:11 +0200

Contact. Don't send messages. What can I do?

Good Job! (reply)

Karachi123 — Thu, 29 Jul 2010 14:01:08 +0200

Great, Keep it up

phpSQLiteCMS admin missing under lighttpd (reply)

Lighttpd tester — Mon, 26 Jul 2010 20:44:23 +0200

Maybe you have same issues I had.

Check http://phpsqlitecms.net/forum/index.php?id=1294

How to run phpSQLiteCMS on lighttpd [tip] (reply)

Lighttpd tester — Mon, 26 Jul 2010 20:38:38 +0200

I also tried this with lighttpd and I had to use two separate rewrite rules to get the content and management to work correctly. I use it in the root directory /

url.rewrite-once = (
^/cms/([^\?.]*)/?$" => "/cms/index.php?qs=$1",
"^/([^\?.]*)/?$" => "/index.php?qs=$1"
)

And here the order is important, ie. the /cms/ rule is before the / rule.

And I am also happy to report that this works like a charm with lighttpd and php fast-cgi run as a separate user.

categories into the media upload?

Andreas — Fri, 23 Jul 2010 20:39:09 +0200

Is there a way to add support for categories into the photo-page?
Because the summary on the server I think of the sub upload photos as MEDIA/animals or MEDIA/nature ...
I think it's possible. But where do I start?
many thanks

notes page templates

moho — Sun, 27 Jun 2010 17:10:29 +0200

it seems in the notes page sub templates, the link part is commented out. Not sure that is intentional or a typo. I basically un-comment it to make it show the links.

News Headlines on Index Page (using simple news) (reply)

Ryan — Wed, 23 Jun 2010 18:38:03 +0200

Here's a function for grabbing the latest simple news headlines as links. Use $limit to determine how many headlines to show at the most.

NOTE: place this function in functions.content.inc.php (new) instead of functions.inc.php as mentioned in my firt post.

function get_simple_news_headlines($limit) {
  $dbr = Database::$content->query("
  SELECT newsitem.id, newsitem.title, newsitem.time, page.page
  FROM ".Database::$db_settings['news_table']." AS newsitem
  LEFT JOIN ".Database::$db_settings['pages_table']." AS page
  ON newsitem.page_id = page.id
  ORDER BY newsitem.time DESC
  LIMIT " . $limit
  );
  $headlines = '';
  while($row=$dbr->fetch()){
    $headlines .= "\"". $row['page'] .",". $row['id'] ."\">". $row['title'] ." \"timestamp\">".date("M jS, Y, g:i a",$row['time'])."
";
  }
  return $headlines;
}

Call the function from any page content like so ...

<ul>[function:get_simple_news_headlines(5)]</ul>

Mysql Engine - Column 'include_news' cannot be null

lma — Wed, 23 Jun 2010 09:44:32 +0200

In Mysql Engine

On add page make this Error:

Message: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'include_news' cannot be null
Code: 23000
File: /www/cms/includes/edit.inc.php
Line: 461

Temporary patсh:
in cms/includes/edit.inc.php
after line 222:
if(empty($_POST['edit_permission_general'])) $_POST['edit_permission_general'] = 0;

add:
// patсh for include_news column error
if(empty($_POST['include_news'])) $_POST['include_news'] = 0;
// end patch

News Headlines on Index Page (reply)

Ryan — Fri, 11 Jun 2010 18:42:07 +0200

you could pull the content_type condition out of the query, it was left there from testing. '' is the default value for content_type as far as the database is concerned, and phpsqlitecms interprets the '' value as text/html.

Let us give the developer an Applause for the new release

moho — Fri, 11 Jun 2010 16:19:59 +0200

Just noticed that the developer released an official 2.0 version. Great job! Thanks for a such an easy and efficient software package. I use Yii Framework to write websites but this software is just so easy and efficient and I use it for small scale websites.

Thanks,

News Headlines on Index Page (reply)

moho — Fri, 11 Jun 2010 16:02:03 +0200

Ryan, Great job. After Section="news" what is the purpose of a null Content_type condition?