phpSQLiteCMS Forum

Nginx config

spikyjt — Sun, 03 Jun 2012 12:59:31 +0000

The docs state Apache is required. I think this is highly unlikely, espescially considering the simplicity of the .htaccss files, and I saw a locked thread here requesting Nginx config and mention of use with Lighttpd. I use Nginx primarily and have setup my install of phpSQLiteCMS with the following config:


server {
 root /path/to/phpsqlitecms;
 index index.php;
 server_name phpsqlitecms.domain;
 access_log /var/log/nginx/phpsqlitecms.access.log;
 error_log /var/log/nginx/phpsqlitecms.error.log warn;
 allow all;
 
 location = /favicon.ico {
  log_not_found off;
  access_log off;
 }

 location = /robots.txt {
  allow all;
  log_not_found off;
  access_log off;
 }

 location ~ /\. {
  deny all;
  access_log off;
  log_not_found off;
 }

 location ^~ /cms/config/ {
  deny all;
 }

 location ^~ /cms/data/ {
  deny all;
 }

 location / {
  try_files $uri $uri/ /index.php?q=$uri&$args;
 }

 location ~* \.(js|css|png|jpg|jpeg|gif|ico)$ {
  expires max;
  log_not_found off;
 }

 error_page 404 500 502 503 504 /index.php;

# THIS IS FOR PHP FPM, YOU MAY HAVE A DIFFERENT SETUP
 location ~ \.php$ {
  try_files $uri =404;
  fastcgi_pass 127.0.0.1:9001;
  include fastcgi_params;
  fastcgi_index index.php;
  fastcgi_split_path_info ^(.+\.php)(/.+)$;
  fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
  fastcgi_param PATH_INFO $fastcgi_path_info;
 }
}

I have found this to work fine, although I've not put a site into production with it yet, so YMMV.

Develop a template / Integrate CMS into an Exisitng Template (reply)

Paul — Fri, 23 Mar 2012 11:48:56 +0000

There is no tutorial or documentation.
You have just adapt the /templates/default.tpl

Develop a template / Integrate CMS into an Exisitng Template

coderhs — Tue, 13 Mar 2012 10:49:51 +0000

I wish to integrate this CMS , into an existing project of mine. Please point me to some tutorial or documentation on Desgin/Template.

Change Number Of Displayed Posts (reply)

natsuto — Fri, 24 Feb 2012 02:57:52 +0000

You can find any language code for the weekly webmasters to upload new articles, information about the different types of programs.

How can insert data into mysql file in a LINUX system from a (reply)

natsuto — Fri, 24 Feb 2012 02:46:35 +0000

MySQL database, web-based adminstration tool Excel file or CSV file import options.

Change Number Of Displayed Posts (reply)

jamhassan — Sun, 19 Feb 2012 12:27:06 +0000

I don't have at this time code but i tell you way that help you to get code w3school. You can find any language code every week web master upload new article that relevant of different type of programming. Which one you use in this web page.

Polish translation files for phpsqlitecms 2.0.4

TKr — Wed, 15 Feb 2012 22:01:20 +0000

Fresh Polish translation files for phpsqlitecms 2.0.4 can be downloaded from here.

This is updated translation of old Andrzej's translation whitch can be found here.

Java.................? (reply)

gang — Wed, 15 Feb 2012 05:24:03 +0000

fine ...

Java.................?

hollybritton — Tue, 14 Feb 2012 10:20:52 +0000

can any one tell me from where i can get java code for free which r only ment to be used in general by student/programmers...

Transfer data from SQLite from android to SQLite in server (reply)

Choosing — Tue, 14 Feb 2012 03:52:07 +0000

Choosing womensTrue Religion the true religion womens Right Leotard

Transfer data from SQLite from android to SQLite in server

Abdulrab Lahson — Tue, 31 Jan 2012 11:02:47 +0000

I want to Transfer data from SQLite from android to SQLite in server.

I've never done this before and I've never used SQLite before

Can someone tell me the best and easiest way to do this

the data I'm collecting is transferred from a sensor to an android via Bluetooth (already done that), Now I want to transfer is from the SQLite on my android to the SQLite on my server so I can present it on my website

thankyou

Change Number Of Displayed Posts

spiralfive — Fri, 20 Jan 2012 17:33:59 +0000

I am trying to setup a new phpSQLiteCMS website where one post is displayed on the homepage at a time (with back/next buttons to navigate between). I have the posts displaying on the homepage, however I cannot figure out how to limit the number of posts displayed on the index to a single post. Is this possible and how would I achieve this?

Thanks In Advance

How can insert data into mysql file in a LINUX system from a (reply)

Paul — Wed, 21 Dec 2011 22:40:32 +0000

What is a

WONODWS machine ?

Don't you have phpMyAdmin installed? This webbased adminstration tool for MySQL-Databases has import options for Excel files or for CSV files.

phpMyAdmin is usally installad on preconfigured webspace.

Have you any idea for the site which provides FREE TEMPLATES (reply)

Paul — Wed, 21 Dec 2011 22:31:29 +0000

http://www.freecsstemplates.org/

Have you any idea for the site which provides FREE TEMPLATES

karina vaughns — Fri, 16 Dec 2011 08:10:17 +0000

Please suggest me the name of the sites which provide FREE templates for website design...

Upload with image modification or thumbnails doesn't work

theand — Thu, 15 Dec 2011 09:07:19 +0000

When trying to upload jpg image with modification or with creating thumbnail an empty page /cms/index.php is shown up. tmp file is presented in file manager after that.
lighttpd logs and php logs are clear.
permissions on directory media is 777

what could be the reason of failure?

Thanks.

How can insert data into mysql file in a LINUX system from a

marysharp — Thu, 15 Dec 2011 07:34:26 +0000

I want to populate data into a mysql file in a LINUX system. The input data is to be taken from a WONODWS machine which is in EXCEL format. Is it possible to achieve this using shell in LINUX?Thanks in advance.

Error on the side

Maxx — Thu, 08 Dec 2011 12:17:41 +0000

Hi,

On some pages in admin-area (e.g. Administration » Notes » example_notes), I get a warning:

***
Meldung: 'Sortable' ist undefiniert
Zeile: 71
Zeichen: 1
Code: 0
URI: http://domainname.de/cms/index.php?mode=notes&edit=example_notes
***

This warning issued only on MSIE 8.0, not on Firefox.

Best regards
Maxx

Italian language files - new urls for DL

misterdimiz — Wed, 30 Nov 2011 19:34:26 +0000

Italian language files for phpSQLiteCMS 2.0.2 available here.

Italian language files for phpSQLiteCMS 2.0.4 available here.

Reguards

Demo site on Spanish URL / URL del sitio demo en Español

gustdom — Mon, 03 Oct 2011 11:45:24 +0000

-- English

The new URL of the phpSQLiteCMS example site on Spanish is:

phpsqlitecms.cu.cc

Cheers!

-- Español

La nueva dirección del sitio web de demostración de phpSQLiteCMS en español es:

phpsqlitecms.cu.cc

Un saludo.