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.

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

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

Thanks In Advance

what could be the reason of failure?

Thanks.

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 for phpSQLiteCMS 2.0.4 available here.

Reguards

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.

Italian language files for phpSQLiteCMS 2.0.4 available here.

Reguards

sqlite on FREENAS

mysql on freenas

what I do wrong?

My phpinfo

Is there a download that does not include all the documentation etc.?

If not:
what pages can I safely delete?(i.e. rss, robots,index,etc)

Is there a way to delete everything at once?

First thx for this great CMS, but i cant search something. I think this is because your download package dont include the search site (and other sites).

If this is so, please correct it.

Stefan

./cms/includes/functions.inc.php line 60 or so:

 
 
  $base_url = $protocol . $_SERVER['HTTP_HOST'];
  if ($_SERVER['SERVER_PORT']!='') {
     $base_url = $base_url . ':' . $_SERVER['SERVER_PORT'];
  }
  $base_url = $base_url . dirname($_SERVER['PHP_SELF']);
 
 

Also ...

SWEET! Nice job, this cms is what I have been looking for!

And ... I noticed the requirements say "Apache" but ... I just got it to work with Hiawatha web server, too. Very straightforward and uncomplicated.

• 1. Download the editor package
  
• 2. Copy the folder tiny_mce into /cms/modules (so the path to tiny_mce.js is /path/to/phpsqlitecms/cms/modules/tiny_mce/tiny_mce.js)
  
• 3. Enable it in Administration → Settings
  
• 4. You can edit js/tiny_mce_init.js to customize TinyMCE

Step #1 should be simple enough to understand. TinyMCE downloads as a zip file. Extract this somewhere handy and you should get a folder named tinymce. This is not the folder referred to in Step #2. Notice the underscore. Within the folder hierarchy of tinymce you will find a folder named tiny_mce (i.e. tinymce/jscripts/tiny_mce). Copy this folder to your web server under the /cms/modules directory. Verify that you can reach the TinyMCE script from your web browser with a path like: http://www.myhost.com/phpsqlitecms/cms/modules/tiny_mce/tiny_mce.js.

For Step #3, access your website using a web browser and login as the administrator. The admin tab should appear above all of your site pages. From the admin tab, select Administration. This will load a page showing the Administration menu, from which you should select Settings. To get to the wysiwyg editor setting, you have to click the small link at the bottom that says ">> Advanced settings". This will bring up a list of variables and flags used by phpsqlitecms. Find the setting "wysiwyg_editor". In the field for this setting, change the zero to a 1. This will activate the wysiwyg editor.

To use the TinyMCE editor, you must enter wysiwyg mode while editing or creating a page. If you have followed the steps above you can check that the editor is working by browsing to your home page and selecting "Edit" from the admin tab to begin editing your home page. At the top right of the page, above the editor box, will be a small gray link that says "WYSIWYG mode". You must click this link to enter wysiwyg mode. When you do, a pop-up should appear warning you to save your changes first. Once you dismiss the popup, the TinyMCE editor should load in the editor box and the "WYSIWYG mode" link will change to say "Text mode".

Sorry about the mess, any ideas will be appreciated

Costas