akira02

Need to add one of this lines depending which version you want on htaccess file.

To switch to PHP 4.4:

AddHandler application/x-httpd-php4 .php
To switch to PHP 5.0:

AddHandler application/x-httpd-php5 .php
To switch to PHP 5.1:

AddHandler application/x-httpd-php51 .php
To switch to PHP 5.2:

AddHandler application/x-httpd-php52 .php
To switch to PHP 5.3:

AddHandler application/x-httpd-php53 .php
To switch to PHP 5.4:

AddHandler application/x-httpd-php54 .php
To switch to PHP 5.5:

AddHandler application/x-httpd-php55 .php
To switch to PHP 5.6:

AddHandler application/x-httpd-php56 .php
To switch to PHP 7:

AddHandler application/x-httpd-php7 .php
To switch to PHP 7.1:

AddHandler application/x-httpd-php71 .php

i fix it, it Wass the version of php 5.6 handled and forced by htaccess. I deleted the code from htaccess that forced that php version and now it’s on 7.4 and works ok, thanks @tijosh !

JOL,

The true truth is that all thats details dont tell me nothing.
The problem that i found wasnt important on that details but the structure of the database for me was very significant.

You must download a .sql backup of the three tables of ngg_ from your wordpress database, then delete this 3 tables, then delete the plugin from wordpress plugins, and then try to install on your server online the plugin.

When you finish to install the plugin, look if the plugin work ok, creating a gallery and uploading 1 image to 1 gallery.

If all are right, just go to your wordpress database, empty the 3 NGG_ tables, import to each table the respective .sql file, then just make the changes that i told.

JOL,

Take a look on ngg_pictures table.

Your problem is part of the same issue.
Check with another nextgen gallery database that works ok, what differences has that one database with yours one not working.

You should found differences between yours ngg_pictures table and the new working one.

Just add the rows, rename it, order just like working one.

After that, you should have your ngg gallery right.

Bsr .cl

I tried with previous version, but my problems still there.

Here i put you the versions that i did found in my clients sites.

https://www.bsr.cl/publica/

Im not really a Expert of Nextgen Gallery, but im with you…there are a tool in nextgen that when you update the plugin, it update your database.

With a tool like that, you will not have to access to Mysql.

Well,…..you not even need acess to SQL tables, just develop a little PHP that makes connection with your database (wordpress) and replace names and attributions. Just that.

[line moderated – please keep the support in the forum]

Only if my problem was your today problem.

OK.

Its me again.

I resolved the last problem, that not store the data on the database ngg_gallery table.
Resolved.

Next problem…at the moment to choose the images you want to upload to X gallery, Nextgen gallery said “0 images uploaded “…

Thats another problem with the order and rows in the database of ngg_pictures:

OLD:

CREATE TABLE IF NOT EXISTS wp_ngg_pictures (
pid bigint(20) NOT NULL auto_increment,
post_id bigint(20) NOT NULL default ‘0’,
galleryid bigint(20) NOT NULL default ‘0’,
filename varchar(255) NOT NULL,
description mediumtext,
alttext mediumtext,
classtext mediumtext,
imagedate datetime NOT NULL default ‘0000-00-00 00:00:00’,
exclude tinyint(4) default ‘0’,
sortorder bigint(20) NOT NULL default ‘0’,
meta_data longtext,
PRIMARY KEY (pid),
KEY post_id (post_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1871 ;

NEW

CREATE TABLE IF NOT EXISTS wp_ngg_pictures (
pid bigint(20) NOT NULL auto_increment,
image_slug varchar(255) NOT NULL,
post_id bigint(20) NOT NULL default ‘0’,
galleryid bigint(20) NOT NULL default ‘0’,
filename varchar(255) NOT NULL,
description mediumtext,
alttext mediumtext,
imagedate datetime NOT NULL default ‘0000-00-00 00:00:00’,
exclude tinyint(4) default ‘0’,
sortorder bigint(20) NOT NULL default ‘0’,
meta_data longtext,
PRIMARY KEY (pid),
KEY post_id (post_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1871 ;

COMPARISON:

Just Delete classtext row and then ADD between PIB and POST_ID the follow:
image_slug varchar(255) NOT NULL,

And then….all will work again, completely again!

??

Benjamin Spencer.

SOLVED!

Explanation above. ^

jusst create a row between NAME and PATH named SLUG….
varchar(255) utf8_general_ci No no

[ Signature moderated. ]

I backup everything, installed all again, part of part… all Work OK.
But at the moment to restore the Database of wp_ngg_gallery, gave me the same problem, not store the new gallery into the database wp_ngg_gallery.

So, i saw the structure, and read the restore sql file, and i found a big error.
My database restore file structure in the table wp_ngg_gallery has 8 rows for registry and the wp_ngg_gallery brand new installed from point 0, has 9….GID, NAME, SLUG, PATH,….

So…in conlcusion….SLUG is the part missing on the database table structure of wp_ngg_gallery to work.

I jusst create a row between NAME and PATH named SLUG….
varchar(255) utf8_general_ci No no

This is the code to create it.

CREATE TABLE IF NOT EXISTS wp_ngg_gallery (
gid bigint(20) NOT NULL auto_increment,
name varchar(255) NOT NULL,
slug varchar(255) NOT NULL,
path mediumtext,
title mediumtext,
galdesc mediumtext,
pageid bigint(20) NOT NULL default ‘0’,
previewpic bigint(20) NOT NULL default ‘0’,
author bigint(20) NOT NULL default ‘0’,
PRIMARY KEY (gid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;

So, with that will work all again OK.

Im hoping that with this….all yours problems gone.
Sorry for my english, im from chile and i speak spanish, but for this thing are no other language than PHP and MYSQL.

lol-.

[ Signature moderated. ]

I turn SAFE_MODE ON verify if that was the problem but doesnt was.
Wordpress Version 3.5.1
Nextgen gallery work fine, but at the moment to create a new gallery, it doesn create in the database.
Im still in the ID #49 on the table galleries.

At the moment to add images to a exist gallery, nextgen said “0 pictures added” or something like that.

In strict rigor, it just upload the picture but not do the work to transform it in a thumbnail.
On the folder are jsut images but in the Thumb folder inside on the folder of the gallery are no one thumb image.

I tried to downgrade to ohter versions of nextgen gallery (1.9.10, 1.9.7 and 1.9.6) and nothing, same error.
Maybe it could be WordPress.

Sistema Operativo : Linux (64 Bit)
Servidor : Apache
Uso de memória : 37.34MB
Versión de MySQL : 5.0.96-community-log
Modo SQL : No definido
Versión de PHP : 5.3.21
Modo seguro PHP : Desactivado
PHP permite URL fopen : Activado
Límite de memoria PHP : 128
Tama?o máximo de archivo PHP : 1000M
Tama?o máximo de entrada PHP : 128M
Límite para el PCRE Backtracking : 500000
Tiempo máximo de ejecución de Scripts PHP : 300Ms
Soporte PHP Exif : Si ( V1.4 )
Soporte PHP IPTC : Si
Soporte PHP XML : Si
Biblioteca gráfica

GD Version : bundled (2.0.34 compatible)
FreeType Support : Si
FreeType Linkage : with freetype
T1Lib Support : No
GIF Read Support : Si
GIF Create Support : Si
JPEG Support : Si
PNG Support : Si
WBMP Support : Si
XPM Support : Si
XBM Support : Si
JIS-mapped Japanese Font Support : No

Thanks