Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#13 2020-02-19 09:40:34

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: Quickly generate a set of (test) articles

phiw13 wrote #321767:

both wet_lorem_ipsum and cbe_rand_content still return error(s), one for each article inserted, same error for both plugins.

Huh, weird. I’m not getting that at all on 4.8.0-dev. Everything inserts fine. If expires is passed nothing it should default to NULL which means ‘no expiry’. Does your DB table definition of Expires in the textpattern table correspond to the new defaults that jakob linked to above?

cbe_rand_content seems to populate that field anyway with a random expiry date – although not every article gets one. wet_lorem_ipsum always sets a blank expiry.

For a bit more debug info, find the safe_insert() call for the textpattern table and change the last line of that call to this:

feed_time       = '$feeddate'", 1

When you then run the plugin you’ll see it dump out the query it’s trying to insert. That should give us a clue as to what the Expiry field is trying to populate. Maybe it should pass null and not '' to fully comply with various DB schemas out there.

Last edited by Bloke (2020-02-19 09:42:48)


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#14 2020-02-19 11:16:19

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,134
GitHub

Re: Quickly generate a set of (test) articles

Aside: how does versioning work when plugins are updated by another plugin author and subsequently distributed? Do we need to maintain community forks (or similar) and indicate they’re not from the original source?

Offline

#15 2020-02-19 11:27:46

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: Quickly generate a set of (test) articles

gaekwad wrote #321779:

Aside: how does versioning work when plugins are updated by another plugin author and subsequently distributed?

Jukka, among others, dislike people using their prefix for forks. And I can see why. For active(ish) members, it makes sense to fork and rebrand. But for those that have fled the nest (e.g. Rob Sable, Yuri ‘Inspired’) I’ve kept their prefixes and just upped the version numbers.

If the original authors that are semi-active here are not interested in upkeep of these plugins and the code has value, I can adopt them and rebrand them no problem.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#16 2020-02-19 11:31:38

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,134
GitHub

Re: Quickly generate a set of (test) articles

Bloke wrote #321782:

Jukka, among others, dislike people using their prefix for forks. And I can see why.

Oh, definitely – 100% agreement. That’s partly why I’m asking, since cbe_* indicates Clare being the source, which is sort of true originally – but mostly not.

Offline

#17 2020-02-19 12:09:40

phiw13
Plugin Author
From: Japan
Registered: 2004-02-27
Posts: 3,058
Website

Re: Quickly generate a set of (test) articles

Bloke wrote #321773:

One MySQL install is v8, the other is v5.7 all PHP 3.11, localhost

Does your DB table definition of Expires in the textpattern table correspond to the new defaults that jakob linked to above?

I would think so… Two of the sites are fairly fresh installs, a third one is my age old playground, which has been running TXP-dev for ages.

For a bit more debug info, find the safe_insert() call for the textpattern table and change the last line of that call to this:

feed_time = '$feeddate'", 1...

When you then run the plugin you’ll see it dump out the query it’s trying to insert. That should give us a clue as to what the Expiry field is trying to populate. Maybe it should pass null and not '' to fully comply with various DB schemas out there.

OK, This is what comes out (I snippet a bit in the actual content)

INSERT INTO textpattern SET Title           = 'Affjwge tgoaej fauloi',
                                       Body            = 'Mhzmcyrw ukya ed iezp paeeoe jasuaey. Akk lfbsmovr gcocvr wbulcia ktuc ej zj. Stiade asazln uxlwze utk khvhgv tiup xcg elvaie. Nzosdba ucoam bc fq rt eefahvg oeov aaatkf. Jjljfd iev oesufisq aa iuhaukkj besyo yoeiiv cop rdqatukr qcvhqnf. Dan na vpf fjhjy ere husxu axaewe qpuc kmezbyl viof.

...
.
',
                                       Body_html       = '<p>Mhzmcyrw ukya ed iezp paeeoe jasuaey. Akk lfbsmovr gcocvr wbulcia ktuc ej zj. Stiade asazln uxlwze utk khvhgv tiup xcg elvaie. Nzosdba ucoam bc fq rt eefahvg oeov aaatkf. Jjljfd iev oesufisq aa iuhaukkj besyo yoeiiv cop rdqatukr qcvhqnf. Dan na vpf fjhjy ere husxu axaewe qpuc kmezbyl viof.</p>

,
                                       Excerpt         = 'Oqra ssuia sauniwt fjoob luaws. Rqhweg oiawas hazai. Ggmt veeype kwpgazue joapuoei mpo ptawkby viuesrs. Uewem edatgofo. Eupcurz tc ji dg. Rdikcugp ij dvdwb. Epeudg ioglb omoiws aushw oe deqqol jq.',
                                       Excerpt_html    = '<p>Oqra ssuia sauniwt fjoob luaws. Rqhweg oiawas hazai. Ggmt veeype kwpgazue joapuoei mpo ptawkby viuesrs. Uewem edatgofo. Eupcurz tc ji dg. Rdikcugp ij dvdwb. Epeudg ioglb omoiws aushw oe deqqol jq.</p>',
                                       Status          = '4',
                                       Posted          = '2019-10-20 03:15:03',
                                       Expires         = '2020-05-20 03:15:03',
                                       AuthorID        = 'txp-dev',
                                       LastMod         = '2020-02-19 21:03:12',
                                       LastModID       = 'txp-dev',
                                       Section         = 'playground',
                                       Category1       = 'meaningful-labor',
                                       Category2       = '',
                                       textile_body    =  1,
                                       textile_excerpt =  1,
                                       Annotate        =  0,
                                       url_title       = 'Affjwgetgoaejfauloi',
                                       AnnotateInvite  = 'Comment',
                                       uid             = 'a7d5f7affde2f2c63f783a6730ac644b',
                                       feed_time       = '2019-10-20'

Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern

Offline

#18 2020-02-19 13:23:24

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: Quickly generate a set of (test) articles

phiw13 wrote #321767:

Posted = ’2019-10-20 03:15:03’, Expires = ’2020-05-20 03:15:03’, AuthorID = ‘txp-dev’, …

Thanks. That’s perfectly valid, which is why your experience in it throwing Incorrect datetime value: '' for column 'Expires' at row 1"... for every article is especially baffling.

The only situation in which I can foresee this being an issue is one where it chooses to assign a NULL (blank) value. Otherwise, it should apply the given expiry date.

Even if a blank value is supplied for this column, MySQL should use the default defined in the column specification: NULL.

So I’m scratching my head a bit. I’ll do a little more experimentation and see if I can get it to misbehave. Admittedly it was late when I hacked the plugins.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#19 2020-02-19 13:37:58

phiw13
Plugin Author
From: Japan
Registered: 2004-02-27
Posts: 3,058
Website

Re: Quickly generate a set of (test) articles

I have absolutely no clue what is happening in the DB, and I am a bit puzzled as well, as

  • the message pane is green and list the ID’s of the inserted articles
  • the expire date is inserted for each article

the one offending line seems to be:

$expires   = ( in_array( $in, array( 0, 4, 8 ) ) ) ? '' : date( "Y-m-d H:i:s", strtotime( "+{$in} months", $seeddate ) ) ;

Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern

Offline

#20 2020-02-19 13:42:34

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: Quickly generate a set of (test) articles

phiw13 wrote #321797:

$expires = ( in_array( $in, array( 0, 4, 8 ) ) ) ? '' : date( "Y-m-d H:i:s", strtotime( "+{$in} months", $seeddate ) ) ;...

Ah, wait, yes, that will probably kill it as I’ve surrounded the safe_insert() expires value with apostrophes already. Good spot, thanks. I must have been statistically (un)lucky when I tried it last night that it didn’t choose an empty value.

I’ll fix this as soon as I can.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#21 2020-02-19 14:02:23

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: Quickly generate a set of (test) articles

Try this tweaked version please:

# cbe_rand_content v0.2.2
# Generate mass (fake) articles and comments
# Claire Brione
# https://github.com/ClaireBrione/cbe_rand_content

# ......................................................................
# This is a plugin for Textpattern - http://textpattern.com/
# To install: textpattern > admin > plugins
# Paste the following text into the 'Install plugin' box:
# ......................................................................

H4sIAAAAAAAAA+082XbbRpbP1ldU0JqAdCiKpCRbpkUmskQnTDuyR5Ldyfj4UCBQJBGDAIJF
S3v0QfmO/NjcWxsKIEBBSs70TB8xORYBVN26+1YFWv1ur/8l7u/2Dd9aUuNl3O8+6xv2lE4i
y3cmduAn1E/w/vO+cUmj2A18vNrrG512r93D7zDBSpNFELHpO33jyLPciJJXEQzmMDtyyCSN
XLyzu983FkkSxv3t7bmbLNJp2w6W23wmn7hdhkW32zccGtuRGyYCld1e3/ie+jSyEkqWVhyT
xsz6TJvEihLX9mhMAAYB6EuAEQvkg8ihHN++sceg9I3kJqTi1o4YNvOseSzu9cSwBfVC/LrT
6wCtB457SVxngDzbCr107vpbbMRwY+Ng0R0WiTjYhpvwKBwekqXru0vLc+OkRaZpQmapbyNV
lkcsBx5uxa5DCQdKkoCEQZh6SOVNkEZEACSJNQUi2wfbIVuyNzzHGySYyRExrNnDZ6k33CDk
wHOHBxZZRHQ2MP42o1aSRjQ2hq/Ft4Nta3iwDYNWxkb0txTEw/k4fMfx0m9WT3X9OLE8bytO
Q2DNmF9ZSCyTDt4OoqR6fhpbc2oM3+Of6lH2wvLn1AvmxvBIfs1GH2wjA5BFTGBllHM+hcPx
DHlMfEqdjM8BSWiccObPIri7RX2nRZKFG0shXbmeR+ZSGVHuwbJcD8ksiBAUlxss+danJImC
FGSHMIN0vujDX3oD8ym5itwEsCCwxk8Iz/JbsFiyIHGwpIm7ROgE7POGeDAQxD91E1QBLwDR
EDeM02WbvAIdo5cAJWBQ4haJKdJmw+wp5fgDSMsnIA4a2VZMGc5ApnhC4LYbANHoLSonKZpA
CPA8Rz9Q5EYZFwSvUA8alhdRy7kh9BoswvXn2UTG1iklHp0lJPWTILUX1GmqdU5THIUcLec1
ctBO4yRYuv9kxoH2tKDK4GJyYAcOHU6YtfqOPQFTm1iokOw+g1Y2BFYQQ/rVuPSFaWbmN6XJ
FQU5dDsMcndPwxtQlQrkECsBnqN4dX1HzMMomFpTF4R9w9dSbEY9RVa5l0BmTPZJAGpBul3S
8KkVeTfkee8/mjq4EFTOjRfEQZWFGahRVwsKeEg0dzodeHoDyM0DhvAzeb0AgemwlDa2QIqh
KyQrIVtkRq/IEixnARezBPDSF68ApJG2sGLiB8SGwfMguunluOKC2vfJDtK/R67AwcNcdvWM
gF+ILBvWiwm17AV7qs+l1zaNwqRPuiSEkfPIChctmAeTQUQCFunh9f6dwKaBc9Png/cycLGA
t6/ZHJuuLQjjtRVXHtdc/zO94fOZCTCtJzOXeg5XroPp0A9AsadDFU+cvH/UdVia0KoOa5bL
zHNmuR5xZ3mjg5VIGtMcfoHvcZ31A3+LaQkoOlNXaQRVilA5A3jgmwmEIpuyu/6NRCMnGKnO
3Og6eVQzo0PcGGcF9JyxUMWTahlXSrCuCNG7Inihebs467k+Cwlgd19od0ujXI2YLYPeMcQG
LwjR7aCjhlhHhd8/p9dJaEEAinyy295r72bZBlukbnQvpiFHQXizHVpxojzyIeY9ZEg4ojEm
N0imWICAZFJfXIBCgPO+RN8CtyEplJftUkbkMwhJ86HHQy0uHjEnBf4lcuPPGDwdawmDWwRC
KfpFiM7+HHQ3TudzzhzADNQRSONJAY8QScas1fCRXIcTx43BLGP5kOdvYKJRnKiI9gtkH9ys
XB40AQkI5MYpTylkRizZNrqGy5hFMgDXJucLCgmCvQiCODMrEpQGXrXmIcFUFG0YQfrgqsfH
WewFrEPPukGVAOBEBCFwYzEyB+CGHk1ojgAbXHeU+sg/cNxLNEuRqsQsvboCz1/QpPIMrqg3
vT3IX25Id4dskU67C/+OfReSIg8026OQgejG1OuSH1MPgywO7sG/r91rIEOljViHQBkCZg9J
kiY9VpFcuvQqCULXboeL8NsQcOy92Nnb3/1byP8aw5kF2khoFAUR5ppM2GFEwewxhylmDZDy
J43murwiovkx7qwFCRvFiNtuF3R7G6qPoahLcDQrVfb3XkDpsv306QZ5Sor1B5Bfv1gCAAiD
s1gwvddhbC8wnA9D5gp2wzBk+J/iLQIt+2TcLfKVYb/KygIPBVnf8ZKUkFy9yp54rv8ZVxLo
X11dtW02aMrGMOzZQFESI+1wvb2xsf2UDKo/5ChA54UGuGbUACE5FEyfNoh59Go0OT05Ppp8
GJ2ejd+emC1iwnImaZKXBcZsb5OjNIpQzAKxEjCjD6OTc5MQAFNUDgETwJxjUYO1QmLGLNkv
AXT27vXPAEcBQo7DtYYWABr7KG5QlHiBfhJEN3OvS4C9UcDyiLbNSYaVAuaBJ5awNtxZg3wH
jtXFpzPLpsBbYrIKGqd+QaEwgWeKgZoYg3oeqjK7TzxwNyn4e3T0oFsxYUi6rD6QGhNRKBR9
AtYSWTdM4EQVEUXwjSY8/FKiEeRdEMculiFqSVGcxDxmslC0qhGcpxyFBkehQXIMbJvg/See
NaWeKUQwGBIzHzTMgsaYR+x+Sizvj9+tJAAtNzdKrK5VXEsUQBk8XOtoNcCY2lrf//G7/8fv
si6g0tOgacX1VwVnlV/1UHqvOqua0tfVW3AeTKaW/Tm/4KvcndwHFzylUKNG9eD7AXJxOYGU
Jriijplno8yi1VMG/w2Nc6yDaA11G5g9JFME3FoAKcwfv9fnKCsDFD2IwDvZa/pqhUyNo5AN
f3W/RSbUd8zCIujJ0dTiBXUqxQa2Dbb6x+81lRPz1gkLyrGpiGLJrH4zT5R1SW1MJHEITaMC
+5ryz8u7nPwZBDVCHZcRdoebhyVu8Z+5BwW9RzbRdTDThmWIfvnNAPIpz5tAORVN0OeA95yY
7Zw3BvtHz8McJsy2HGcSRu5l3Cg4VfDYXagn5biIziHxA7DgPQAqVcmkWfTGLTI/v07WeZ1m
ESYijfazMslzZ9S+ATvEgMb7ZxN1r61RxlauDTYKUnhurgQSBuAOyQ2yCFM7PB+Pvx+fn5lc
CTtsFfXs8M27Hw5/Ovzx/RnQ2C17Nj5hz3ocu5JQwnvE1w3y9SZ+beFf69olzY0vG08w8vFL
QArW3njyRFwSNhphaoMOxF2MiTDSYmahRuJc/DYQo1/q0NhYuHO7cSvDKQuIWNwuiQiZZBOT
CSxaiR1f8moCyiheC0OtJOqRWRQs9ckQtxH6puWFkPKnS4KN+ELEFQtkH9FbRdgsDq+yrpGh
08qAw1dMHpCv6qt1TTj7gC2b1pEFBfZAxlcuXulBjE63t7O79+z5/gsD2CN9TyZnNujw1dHx
6PX3P4x//Pubn07evvvP07Pz9x/+8fMv/7U6CRWATbKsqe1QOpsvXPfXz5YHvj0Iwt+gKEzT
yyvr+uaf2eSmEuxXwL2JQFWjMYe8jl9uWbRV1BnBY6UsSopfgVrNLA9k9vXXjOMNAn6j20E1
h0d7HaVK/2AyHmA57EEd0iBGy2hpkJpcndh3pnR8xkeO6YTDlmCa5BMbLlOdzQwEaN+TEuMo
lSnnEr8Go4NVxTJVg58wfLk6gMJ5FNdm+vBR085PMHYLrJkBZ5hBtmnidKhyYMJnpkwv8csB
yVbHG998w22UzWoPyoB/FEh2BPc4bp8y4aihIAChnCAcBvJj5xNLfTtmtgy7t26hbslCq4y/
LXVOWBhU8FMZ1H2k9WQTnLeyPXXnI5Kg2TVTybxWd0m90aj3mgvY6moobAkgkvpfAxf+NVCP
Ea3mGkbInq5gGYIGJJ635CVnCFxit0483VOXd7FLgtTBMUzLBssVdOhVvF0GWIhKs6hchuu1
K/WaBxKciheo09wJlPDeZPtPLbb/1HICuDILkqhE9zYTxN2ib0thkUxabWK2zTUyw1QJyELR
aRLhl0pea6RZLS8JUgdXKa9KrpfIK1xEVkw1kVWuVCYyOfsOqZUps4YcJCstsr8io1X+c87f
kSpv18q41nRWRKfYjInKHbEnxRr5FZBWugFY5ReaAXLTne0W2hFlNUiLtRxi7EbTCG+oRpLN
+qCYa8PC1X0B3o1ibQFVdZwEyYJtdiasp7oMsKjL1fos8b0t6WLw9tY6zNMQN9Yk3vzqvkjL
JtqfRFvBU3KaiEY+SCpPwoyVtKzNLKhxY6IGF3sxl4HrFLFft1iOkk1ZUFBnInt5AzKnyQRZ
tlJciCFYsfiBT7l7EaB46lQCDtt+hR4eMz4tmVUJGL++JRTc3DqAankdzEo3tACwYrDqkr6U
o+W0+G4+FClbrRjfnY5eT34YHx+P4KGZY1ldRaE+anMtNRFDH6gkYnZORaSHW69Toj5dS4ZD
cYukFhli6APJELNzZMTWTD6AuIz7UMwpgAgN1ucdmEah5G4bpkEyragWltZBzpAod0vqcaGA
VBUkw4Uff+L959JRYBEhEaPwez0mleLZkGtiFt8SoFlGr3OP2SJ7BMm2G7P2A6oK3MU1iGbi
rBFjZMJg0wxWahUtXswW2lPB59Iwdm5NiZnt+pnl0bMy2rnY2csL6DXuP5IYYh31i2p3R7tb
QmRNCogpbNP0681FsvRyTJQ9Ls5vqVebPiRiE8H2k/dv3mRPihmQdp/lLJDlLBtkAZpe3pdS
veIma7GUNQ7bfhti5Rwyy7EfpgDCjNPp0k3QxatvVcBF27SJY5foCKJpcG2WL6StF4ulCr27
DNs75lMxXzBy3XDAzHEvK0C2mMbjsU53dtMA+2d0mlZEJzdBOonTiJpN8AJNgzyU+2x/4P8N
9zm2/7e5z6xqIPJt82ARke2hqZLul4WgpRlXMUCtHHYrOAS1TSy3S4RXOKOUGKun3NRZBDz9
OnO9YgfvLicikLiXD8GiUWyUTAIfotvMSr3cXXELXNSlC6Tc7XNc3/ZShwI4mxKIklayaJvb
njvdtj0rjvEkDNCGG9ZmpZsStxFVGkUeHquRPSLxSFDIrwbrNZzvmGRwMRQ1NtOYsgoWkMkl
rKb2AGaxPt37s9HkfPTz+fjNqJAxPoBalRxu8u3zWNDA8gs78NKlP/FTcAwmdofQkDHXwF0L
lmtcsA2Ji4NnemqxGQax3IwHUHaQ+mhgcgHVbxOjYypObdZYWIxlS4OKsHO7IbD+YtAlhyfH
5AIHX3w1MIWmmEW8BAAdL7V+ETFxMNEF07gTMXmIETHLsIiCAAIAQwy74BcDuVm5gpecr+Gl
Lb/CsgQq2KyrfXZ+eP7+bPJm/GHU0i9KfZkacXx6+Pp8/ZB7QuRlwV8K8t3o5Hh88v1fAbOg
CMDCNNbVgPG0yGlwZv4URsn2aqeFR480UNah68Rl/kLzFUacsurcyACXdXT4Wlo/RyMDtJQ6
7OStahfh4atGc6ux0+k87e0+fdaB/yF68tvfNJ5pdzWEGTDw7eIzyBrUL4qjBIvYKM4evZ2d
8ZD3mbWJ4hgw9mzYUeAGMX7ZWm455Ie+24+NlkZNYUlwU8ky4JsKJTOLw/np0ZgNb+h7J9jj
Et8B113e4sL/vgWzTT3PJH0C9VC7FDsoS5KAsZEY33wBWLfilHMBcwznRg6fmSYkHfQ6kpWn
ZI197iMLfBZDVvisnBkTkHBjRRmJMSuTpcfp4uTM1xSmK79UnM/jljq7jUCwr4r6/C0Gx35N
oCykacjkI1oO014+7OLnVqeInRkXWg3pJoixUdoH3Wlhb3gHj/eCvQBOYqtAA5VG3oSDY3tH
bngWWqyFym7KDYq8KrJD52zxYlf6WYs5DtVp1aUfRXjCvMSBcEvC08bKSAHAXgEA9yO/Sj/y
K+sMs0l4JfxIgZ9iTcj626W47jP+dDus6+5X81sgznNXbCpLYgq8ia/cxF4AmnqWk8eLvZyi
Jzb9ItJZdoRHWUUq09BTJSewMchmhxZy8xGxCcs/mYgUvK0hHumOUbYK98JUIdqJyNXLpkrp
r86eRtT6nOcHI/bN6PADJ3fy/uT87fujH0bHq1QXsAZNXNZHVIy+P25Hb08+jE7PIZSejF6d
jg7/fnYnZr7Xm4Im5hG8G8X8tAzTWriKHG8FNzk0u3O7UfBcm7zp78i8jl+Cu9YOtRqtNbWg
/jHOlePhH3BT3FGYdUGQV8ixAgjk4v0gKIFoENi9+mBGyo9lYIRc7g1E0w8zJ/n6kM5UDpKh
w9OO+jDeBex4fw6GSlHuQ5RMNiQYmX/UBnHIAvn4WMeEB/f6aLyBFOmnICMHYYi06d5AFCYP
QeRMZR8ZDFWf1QVypAJ/BkQlA/cH0ysB06sPRnj2yVRY44Dkgta94UiH9lA4h74fJCyflGSV
t0jqwsvSGgkPc+DgDPRn0ciSHkxs743jmPdkOOvLGzb1gaauk7tmiC6dvUbqu7+5ToPlQ81W
EqW0eS9sMUOfYG6fAVZZu2nUg9IsTaqwDmSNVBVbcsGqZM+OzVNlIsfGuLIi3/XnxmroLDSg
RpPR6enbU0JKE7Tblf7uPLIg8LH2bJ0GFbZhQ4vtjRLWPRoYZlth2zaNij5om5h9mKKOcLTY
GQJeJec2Rvh5N7oMEyzYcsTlN1dUew2yVZOY7XL0cyeE9Q4rHitludODGtPquDgyRAQNs7xJ
vKYbLbdUqtrRNRvRqgFdbCAz1cnycHlihrf0OQf+RDMZrLmqmVx4tajQTFa/0vAXNJMB1n2b
yehxJQq5LrIbs33hCX9p+QE7V+UWqbeErTHrCrHkMgquYrCE8XGLnPPyEbzYNfNCkMoswwZP
UJr4Il3Kv6PZ6KlolWPCPiifcXEw8IMrwO7w5HiNG2tciDTmYsiHgwdRt8j4jBF+F5ALnpVd
DIy21nRrG3dNk6HiYmB2S8/988/b0+PRKXn1CxkfG6seIyfWgieu5yNr9etX3uNYf/5Cwbxn
+1/S1djELWb0uKwdU6GqT8n+s91Op0mGpFMShPjp2yvL+9zgGljJ4xY/BUUn0trAJX69eQlW
8hlbNOgXNy8/os4aBINHQzQb4aYhVfQT6zVgSw3vwshPpC/OF79ct++GZzQlrSUVorAcTgs4
C6BbUFOG9OYl4qpcWoZzkyFRWCBXB4KHwte1BXA0vk35Avoqa1FGWaf0RXZiuoRMPJTg+inN
JwCMONlO5qB2RJdllQdH5U1lNWB9c1mj8F5NZgUe9W+12aYe39mVyiNwr+5UHgcM+QfhEPOJ
9U01SDvw1eNyhG/LiFzfBshe7K6ZFIoP2xOz8J1N1wE390Wq1EdzfGx+uq2fqMoP30samAa7
ahOZra+c295tkeek2cYMqeTRC2YLbXKPVFlhQJeW60kUyjAoPZUt8flujae/16d994IvcMH2
/9aCO4VE9UFLPEQgV3SqNEIXiClecNY0YK1o/v05JaIy55bGKe5dHmoQIc+4uAg0qKW7SfJl
GOEHsvApt+rEizv3RCL/QTru56jKilj54fFnTTErPxVFrYJTu7hVM2olcGr5jeJ14QY/Iq2y
xYk6iiCEoSULK6G6pG7OnDnL481PdYrkqor4KKuIKyhYXyGvthIeVievsvM2Xzv/e5fOf2nd
vHIulb++WqieR34S3ZAQlk3+1edmOX6NrGbmZJUU1figVTzsKX55SL6WLPmv8fhLQZxCR83b
Qr1cHMd2CW7xkRinCutLSEawJmIS0F7trNSbwZCHpDvcY6vyACdCwE7jQwDwX1SoB2C11BVK
lis0RYOiktyVk11XC7ZTqs47T8EJ2kzoQqZFljYrT0Ub2vHnUqz4Aeg1Ym9VirrkhQU82ZUE
YUXDUn9NvQRspmkaX6m9CMi6U655oGZXd+1QFGzhT+RhBCu4I3HutYI24Xx0UOBCtvhhsiKo
qrPjt/ieTtUPo2xsyFdM+BvpDn8pQA01hcQ29LdTKiAyV23/tx3HAmzpvNy01Idl8deK9vkP
qoKTuXr8UdXHH1V9/FHVxx9VffxR1ccfVX38UdXHH1V9/FHVxx9VffxR1ccfVf2X/agqVCJL
Z4+XJX2j25vZey9sqzd1rE53//nU7j63es6uZT2j+7ZNjZe3/wNTi55ZT2MAAA==

The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#22 2020-02-19 22:04:13

phiw13
Plugin Author
From: Japan
Registered: 2004-02-27
Posts: 3,058
Website

Re: Quickly generate a set of (test) articles

Works great now, thank you.


Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern

Offline

#23 2020-02-26 20:34:07

jakob
Admin
From: Germany
Registered: 2005-01-20
Posts: 4,578
Website

Re: Quickly generate a set of (test) articles

Bloke wrote #321796:

… Even if a blank value is supplied for this column, MySQL should use the default defined in the column specification: NULL. So I’m scratching my head a bit.

With your updated wet_lorem_ipsum I made two modifications and it seems to work:

Expires         =  NULL,

and

LastMod         =  DATE_SUB(now(), INTERVAL ".mt_rand(0, 3600*24*7)." SECOND),

With those two changed, you can specify how many articles it will create. I’m not sure if LastMod can be made to be the same as publish. In my brief testing, the LastMod was still marginally later than Published.

# Name: wet_lorem_ipsum v0.2.1 (compressed)
# Type: Admin plugin
# Create new articles as test data
# Author: Robert Wetzlmayr
# URL: http://wetzlmayr.com/
# Recommended load order: 5

# .....................................................................
# This is a plugin for Textpattern CMS - http://textpattern.com/
# To install: textpattern > admin > plugins
# Paste the following text into the 'Install plugin' box:
# .....................................................................

H4sIAAAAAAAAA61Z624bNxb+rQB9B65grKRUlWQ7abKK7a6beFtjnctGdneBphhQM5TEZjQz
4UWOWwTog+y+XJ9kv8PLzEi2i6JoLrZEHp7L951zSM7w6f7+9Gc9fTTtFnwtus/0dP/xtHst
TJKXSqwTWWm7puEvp11uzapUTgbf3pZzoQz7tzA/5Wt+48cnUSqxStLIwf60uzKmmo7H11Fy
lJbrMU0+mXY3QmlZFvQNdiejg9G+U4RlmdCpkpUJ04cH0+5zJbgRrBDXjCsj01xoxjUzQhuW
ccNJDqGkZeZCeTKZHOJbzrVmOyF99uDnzx50tOHQwiolN6R377pUmWbHUK74TR8Cnd4FrekN
Geu5dfjUy0ooog9aGvoF4NzvtCy0SI0w1s3yTFZSp7JY0jeRQxgaB88+e3CH5aXii7ssM2eV
OZMM9hgZG7KWKdbYYWRkxF7ZImUbaTiQkjpnWmTsR6tNyapSGSMNVC24TeXcaiYLN+9XvhF5
LgrA+cEKthGFKOClZitRZEooWJfrSqhMCsjOsIobtilzayp8gClJtvOcMyiHkaEbI18zuYZa
xKH5UhpS6QL4YDliWfNlwdkCHugt2ZynVg+ZsI1VVmayZLkomQXhkq+DwTWczRnUrUMgL8pC
pAE7LdZDNpdzBEHfAobMyCKVmS0M1knY0RYYVpiF6lwubc5H7CUXKTDQUL+SKYaGzrgkvIRc
QCOATCU8Jw3cLi1BPl8xXWbcJSfAdCHwXDr3MiuhIjVAXkTMTsMc+cHgGuaIEgdeQ8JCgWGZ
k1sEvVhivWfVQTf0I9GwUHyXT/IadcLTgHWDqs2NkqnQOwsWQgUqBDxbly5qPwJJVSJ1kH/I
PUJfgslGI/5JqFGEOECrfXc8gZBRb+hynCJpiKD05Aghz2Uqjc1kASYJFKKaiUKCyHWJ8IwU
RJNO4ZCSzlkL+8oa5bz1VAAoqyuQJLUW3kdWoDYo5aDE8oyTo7l1dBRlMdzSSDniwvOAh1B9
agwZCnYjoYBKgBya29zlWjak+IADOeiAHrF/ILVEVECxDNtFi24IbMsGXFA0bJWqr+Q1R0cN
rrhEsQpV4/LElVyDYquGIk2ZXCKbNOGneSVF4ZNlY/PKGuo/wQeYtQpYcJXalgfe9pBSp02O
p4UKArqCf4HXrTyiUvToYw0lJpW2LCSv20EsWDDnqp7I8OXcuLidFi9LNZd1thsgDj89tJRi
DRo+1xfCLuUWVSP23Co+l9RByXQGXKgfxtL/w933uyYbCkHhe8SHdQtw7NXVAW+HDT+EEGC0
OnZShwqqlogGFcRGteJKGAXKIWkkmXCqiVCE7gDEclhCwD4Ah37khmZSqzS1ICKlMb6WjXIy
7FprWirK5tC0apuhMn1yetKa1gr2rW73rrjbcN9ena4ROzOUQE2eebwgI1QJJjgoED70yuYb
WXAVemzddEfsHEAu4V975yhVKkPM3ssa7dBdo6OhGJq+RbaXwBst37XfCmBIG7eZ2m5rZwg9
q9U3/H5GGdzaLcM2FWu9RPEq0eyCKNQV1x62OtYGGJ/YLnGwZMNzymlXSTVfPG3rIPaoMN0G
EYn3NQYFy63d3enhW3v7eRFhGAZugU3Aou7AQ49zaGuNX87msImtRpQ2w1CP5IjDCbsfHOFF
INblfmu3RrL4s4Rvz+0mF5tmTTIseXqpClx3jPtaDWnNAzet3S12+eCJa42BoJipHjrua5H7
s0fcblq41VlRZ1gF+BzAIdqtxlgfIiQwJlhCP0MTwbFwbeuBsNFTYE5Z3I8pyfJyjjwhHrE/
1qeYpjCaw1udK75X04Gg5fuV2eprrjVQP3Z9MDTYjcR5XXGXICugsaIGyml3RZxGcOACvNba
p5BLQjCp3HHN9b56967TL5xm4iFECh13zUCVVxn8cKfVdcxhx9TW2UK2eB0xl/f3HLgpUNws
Err2aC8yfvgQP9lD9m1ZvmdX57STG1u5NTKnLHbTY/xc4BhBy1mSEGjIg9T0B5igW0VHLljf
fKxc10HLEOz4mK4Da1n0BsxJdHiWJaRX93s7NxO6LOwPD3rkNwSVWKLjCpUYPu/TFcMgOJK5
vWx5+dHcVjfYVZSiTOc8fd/3d40keX5xOpslCXRa2RvcoTpA2Omguyym023scGnRfCGAA7a8
ot+jQfIPACRBkL7SMPvLMXvXywS2g9y864UQP+HHp20CrjQSt4avRj1wWINvZYP5EnXAc/Bq
RBXc3YN3OGEAftbrOVN74PUYe5gV/uuGq+bS1YtXSne1857rOnbxEZUDkivN+27dIM4Q2/MS
PgnVd+aHrVtcp0dMmxVyVPfY8YkzThODQUyFBZDm6Yp5tXSfpQ9x1qnfoxGgR4HUEx0/CvdR
gMokwMsL1nR1OuMxO1+gE5XUM1HyS3eBVuwnFOWUta7T4fCpw7rG6AmbNBY7ewvmUjlLeiOa
flZPANmHyASfIIvGETf7KXrcMNLHigH7KiRt+R5xTQNufqigsSE7S87evn39Nqrymj6FvKFf
FfSZsvKr6mTGymhsEKi35vsfYHglsv49lTJkBzvCSEIcPy/4XORb+bE4p/F+zyAt3F2/mdqL
nzHca/6fv3pzdZm8Pfvm6uL0bRiuVw22vsCF8bhz+frF63scqZPztiOtqVimv8ORJtvvSv3a
CXpI0Y8WtZ2v/fOPuvVovhFORWXnaOEr9J5RMXKMCb+q4SdO6KCuVSZ1yaUrXG5LtfaVVIwM
X/Z/xH2mTybJK2hpHO7Fuuu5Jz6u2qgLfSEy+DkYOCUtLKpSO/dp+gsyEyYaH5/d7kynWbb1
+One3kTxRKH+nq/AW82KeqRF8YaA/479JjE4xSa5BLb9SchGIhcbEBgg0+8u8bXiBnVcuM+Y
evcGrQP9p6aMtMbOLHTKK9GvrW1rTeZldgPR+rv4iE5WGQxdzc6Sy7P/XJ5fnN1unzQA1FDI
EoOTZwy/j1iIlL59/nlsHHuX0jj32+7UMDNs1Pg7Yp5a7NqhjTg2E8WLrFz3Q2dxT+hwgTdu
vH9A50zY25oe0B/fL/a+9sE51QVly/2q3SO4+1W76R3Nycqs81swexy/OKmIk74T3PVna4ET
CPNW5ciA22its8d9W8gPMus771BlxEPjzswXwc6y+6Pd2sOHbL9WlNJRc53s/25NgZJbGg7+
uIZ/ipv4KLatwSfI8M/LEG8tbF1kSBa0lfp+0+maptC6wzDmU7n5g+3Qp3cvSHQcxTsSNLYl
4DNnW8CN1VJnoQxbanbnaiXtufM1bbDsznU1ri3LcawWmqGTWd1WwLqj2eXp5dUsuTj/7mwU
sei8QQfF4b0t+eL08iyZXX3dL8prStLzV5dnb787vYCKyMhkyA6/nEweHjx6+GQw6rLZ2fPX
r14MmtgqqYRuK311dXERp0/d64XzF+0QqKnV7l9wbV6W2Z/rVFBam22DGiuv7dEsbklB5jnO
WctS3ezfsT7OHdwxt9Wjg+722C3Bpnn3dht6LXtaFKV7pNYgNIlzJV3wZCYS2hB3nGl6Uwv6
OHZL+3mxkWSjraHuLS0NcWxX6OAOoYPGF9nKOy8EMu9rkqNuvXAhROb22HqhS4qum449IRwt
Fd2EC5w03v/GSSAel37zJBCFbp0Egol4JfE24iX1lqZ2u8M5U+EUVOBufIzWGRXqlV0scuGm
fTsNJvpelGRx7Kbp7yc/xDN3onOZiqBz4tXG44/ziSLdOS9jOrxvMzeVf3U47R6GN3noKEKF
scdhbJHzpQ5jk7B0JfLKvV58AoGj1eHJG6twMBNHY3x+8OCoOvGXFN288LuWZsU8CPIntJ9w
J2amBBdqI7beCLLM0vMBVuEqiYzmuKUxJTZSXNPzqIyZlWC5fC9GR+OK7MHqt+U16bKNE2V+
8qBzlMuTV3wjl8QM5o84WymxOI6vNx89nYzI7PgrsYE7x7vvUGE2P+4W5aLM8/K6e/I8uP3X
JU5LO8JHY34Cj2DR2z2jq7DzNRMa3TGLV7pysXUaba/5Vhr26y//neFM/usv/2vPzOjhFGK/
5u7ZmXCvSIARMoxMtKGC/pvSKvbyZvavCw+vqnG72wcG7SmHKv4eGQwsFE66a1lYIhHyMneL
y4qeZFFWL2SBu0Lt/NGY4HZMXCAn4UWTC5cr3GGr3C5lQbdZICo4PR62RRbw2WXl+vp6tCzs
qFTLMaU49nc9Xlb5yHw0tyj5prDsG1E4j9/QFSZltQuOkOrEvYmedtFp4jvp/cMvn4hHTxdP
nyy4mIv9g6dzfvi3LM3mjycHj9P97rNP/wff0LfuZh8AAA==

TXP Builders – finely-crafted code, design and txp

Offline

#24 2020-05-20 23:16:44

marios2
Member
From: Germany
Registered: 2019-07-31
Posts: 76

Re: Quickly generate a set of (test) articles

The cbe_rand_content plugin works on 4.8

The wet_lorem_ipsum doesn’t. The content.lorem_ipsum menu location doesn’t show up on the content menu.

thanks.marios

Last edited by marios2 (2020-05-21 12:45:37)

Offline

Board footer

Powered by FluxBB