Hi,
Thanks for coming in and have a look at this old script.
Around 2008, it was given for free against 5 posts in some old forum before becoming “abandoned ware”, the forum is gone too now.
It is a great “membership management” tool, it even “drips” updates, well it was dripping update until some new version of PHP became the rule. Then the script exploded.
So far I understood that I had to change in “updatem.sql”:
TYPE=MyISAM; into ENGINE= MyISAM
but then this happened, looking likes “rows” are not written into “Tables” the right way.
See error code at the bottom of this page.
I tried in phpMyAdmin to add a row with some data, but no joy.
I fear, as a php ignoramus, from what I read on the forum that the problem is more involved than that, but it my be just child play for a phpdoctor.
Deprecated php, “magic_quotes” and more like “phdr” says in this post
Well, for me it feels like I’ve stepped on an alien mine and I’m trying to desarm it with an old babana following clues coming from a walkie-talkie speaking only in Venusian. It is not going to end well…
I’m too old to spend more than a few hours per day at a desk fumbling with php, so if anyone can help and make it work it would be fantastique and save my old skin.
Hey, as it is “abandoned-ware” it might even replace the “Pluck CMS” on the forum that looks like is dead since a good while.
Anyways, thanks for taking a look and grateful tanks if you can make it work.
You can download, from my website under development, the script here memberware-updatem-3.0.1
User
phpdoctor
Password
iamaphpdoctor@2020
Cordially.
MJT
After importing moded with TYPE=MyISAM; into ENGINE= MyISAM “updatem.sql” into a clean database
No Joy!
Import has been successfully finished, 6 queries executed. (updatem.sql)
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 seconds.)
# Table structure for table updates # DROP TABLE IF EXISTS updates
[Edit inline] [ Edit ] [ Create PHP code ]
Note: #1051 Unknown table 'mydatabase01.updates'
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0016 seconds.)
CREATE TABLE updates ( id int(11) NOT NULL auto_increment, name varchar(100) NOT NULL default '', description varchar(255) NOT NULL default '', category varchar(100) NOT NULL default '', position int(11) NOT NULL default '0', thumbnail varchar(255) NOT NULL default '', tpl_file varchar(255) NOT NULL default '', showhist tinyint(4) NOT NULL default '0', active tinyint(4) NOT NULL default '0', rank_points int(11) NOT NULL default '0', votes int(11) NOT NULL default '0', histhits int(11) NOT NULL default '0', numseen int(11) NOT NULL default '0', numhist int(11) NOT NULL default '0', PRIMARY KEY (id), KEY position (position) ) ENGINE=MyISAM
[Edit inline] [ Edit ] [ Create PHP code ]
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 seconds.)
# -------------------------------------------------------- # # Table structure for table `user_seen_updates` # DROP TABLE IF EXISTS user_seen_updates
[Edit inline] [ Edit ] [ Create PHP code ]
Note: #1051 Unknown table 'mydatabase01.user_seen_updates'
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0013 seconds.)
CREATE TABLE user_seen_updates ( id int(11) NOT NULL auto_increment, user_id int(11) NOT NULL default '0', update_id int(11) NOT NULL default '0', order_seen int(11) NOT NULL default '0', vote tinyint(4) NOT NULL default '0', showhist tinyint(4) NOT NULL default '0', active tinyint(4) NOT NULL default '0', histhits tinyint(4) NOT NULL default '0', wasViewed char(1) NOT NULL default '', PRIMARY KEY (id), KEY user_id (user_id), KEY update_id (update_id) ) ENGINE=MyISAM
[Edit inline] [ Edit ] [ Create PHP code ]
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 seconds.)
# -------------------------------------------------------- # # Table structure for table `users` # DROP TABLE IF EXISTS users
[Edit inline] [ Edit ] [ Create PHP code ]
Note: #1051 Unknown table 'mydatabase01.users'
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0014 seconds.)
CREATE TABLE users ( id int(11) NOT NULL auto_increment, username varchar(100) NOT NULL default '', firstvisit_time int(14) default NULL, lastupdate_time int(14) default NULL, lastupdate_id int(11) NOT NULL default '0', lastupdate_pos int(11) NOT NULL default '0', total_hits int(11) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY username (username) ) ENGINE=MyISAM