Corrupt Install

Permalink Browser Info Environment
Hey,

I am running 5.6.3.5 and I tried installing version 1.1.4 as I think that is the correct version? It looks like the install is corrupt and when I try to edit the install and just takes me back to the plugins/block list page. I tried to remove the block with phpmyadmin and I don't see it listed in BlockType table. Any suggestions?

Type: Discussion
Status: In Progress
getdistinct
View Replies:
getdistinct replied on at Permalink Reply
getdistinct
I was able to fix the problem. I deleted the database row in packages and reinstalled.
getdistinct replied on at Permalink Reply
getdistinct
I lied. It looks like the Addon is installed now, but when I go to the dashboard > Page Password, the page loads but there is no password manager or anything. Just a blank page.

Getting the following Error:

mysqli error: [1146: Table '*********.PagePassword' doesn't exist] in EXECUTE("select COUNT(*) as c from PagePassword where cID='46' UNION select COUNT(*) as c from PagePassword where recursive=1")
hanicker replied on at Permalink Reply
hanicker
Hi. Some tables installed by the package are missing.
Can you try running the following in phpmyadmin?
CREATE TABLE PagePassword (cID INT UNSIGNED NOT NULL, passwordID INT UNSIGNED NOT NULL, `recursive` INT DEFAULT NULL, PRIMARY KEY(cID, passwordID));
CREATE TABLE PagePasswordPasswords (passwordID INT UNSIGNED NOT NULL AUTO_INCREMENT, `value` VARCHAR(256), PRIMARY KEY(passwordID));


Thanks
Regards

Nicola
getdistinct replied on at Permalink Reply 1 Attachment
getdistinct
Hi Nicola,

Thanks for the help, but it looks like the tables are already created. See attached screen shot.

Error

SQL query:

CREATE TABLE PagePassword(
cID INT UNSIGNED NOT NULL ,
passwordID INT UNSIGNED NOT NULL ,
`recursive` INT DEFAULT NULL ,
PRIMARY KEY ( cID, passwordID )
);

MySQL said: Documentation
#1050 - Table 'PagePassword' already exists
hanicker replied on at Permalink Reply
hanicker
Hi, sorry for this late reply. Is it possible for you to give me a temporary ftp and administrator access?
Thanks
Regards

Nicola
hanicker replied on at Permalink Reply
hanicker
Hi, sorry for this late reply. Is it possible for you to give me a temporary ftp and administrator access?
Thanks
Regards

Nicola

concrete5 Environment Information

# concrete5 Version
5.6.3.5

# concrete5 Packages
Advanced Forms (1.11.1), Are You A Human (1.0.1), Designer Content Pro (1.2.3), Designer Content Pro - Custom Block Storage (1.0), FlexSlider (2.1.2), Force SSL (2.6), Magnific Popup (0.9.7), Migration Tool (0.9.7), Mosaic Gallery (1.2.1), Page password (1.1.4), reCAPTCHA (0.9.2), Reviews (1.4.1), Sortable Responsive Gallery (1.8), Testimonials (1.5), Zoom Image (1.0.5), Zoom Image Dual (1.1).

# concrete5 Overrides
blocks/form, blocks/reviews, blocks/autonav, blocks/search, blocks/content, blocks/slideshow, blocks/youtube, elements/header_required.php, single_pages/insulation-removal-products.php, single_pages/checkout.php, single_pages/insulation-removal-results.php, single_pages/connecting-insulation-removal-bags.php, themes/VacBags, themes/toughbags

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - On - If blocks on the particular page allow it.
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache

# Server API
cgi-fcgi

# PHP Version
5.6.27

# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, htscanner, iconv, imap, intl, ionCube Loader, json, libxml, mbstring, mcrypt, mhash, mysql, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, Reflection, session, SimpleXML, soap, sockets, SPL, sqlite3, standard, tidy, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib.

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 4000
memory_limit - 512M
post_max_size - 128M
sql.safe_mode - Off
upload_max_filesize - 128M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:59.0) Gecko/20100101 Firefox/59.0

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.