Show Posts


Topics - Palamedes

Pages: [1] 2
1
Upgrade / 0.92 upgrade only mysql update fails
« on: April 10, 2012, 11:06:17 AM »
When attempting to use either the SOURCE or the shell method of db update as provided here;
http://www.mysqlfaqs.net/mysql-faqs/Client-Server-Commands/How-to-run-SQL-script-files-in-mysql-client

the update sql script fails at both the --server line and the set @block_id line.

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--server
('server', 'config_upload_max_size', '16000'),
('server', 'config_store' at line 2
Query OK, 1 row affected (0.00 sec)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@block_id' at line 1

~$ mysql --version
mysql  Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1

2
General Support / 0.92 to 1.0 feature update list
« on: March 27, 2012, 09:06:29 PM »
Is there a list of all the features and bugfixes that got addressed from 0.92 to 1.0 please.

You should keep a running list of information like this.

3
When you're entering the height, width, length and weight for a product should you enter the actual size, or the shipping box size?

Is the purpose here to give better stats to the user about the product, or the final boxed size that the various shipping modules can use to determine cost of freight?

Thanks

4
Support / Tags with spaces = fail
« on: March 15, 2012, 08:01:09 PM »
Create a product and give it a tag "test tag".  Now visit that products page and click the "test tag" tag, the search results return nothing because space gets turned into %20 in the URL which doesn't get url decoded back for the query..

I imagine other special characters would also fail.  Tags should be stripped of all special characters except only those legal as a tag in a url .

Again this is something I could have fixed for you if there was a git repo..  :)

5
General Support / Is it safe to enter a large dataset yet?
« on: March 14, 2012, 10:50:29 AM »
So is it safe for me to enter a bunch of real data into AbanteCart?

I'm wondering if data migration from one version to the next can be assured at this point?

6
When listing products on the admin products page, I'd really like to be able to see the SKU.. 

To that end I'd suggest to create a way to make the visible columns editable by admin..

(Or, if you open up the source via git community developers can work on that for you =)

7
General Discussion / Git Repository for community involvement
« on: March 08, 2012, 05:48:29 PM »
So what are the chances of getting a GIT repository so that developers like myself can help contribute?

The nice thing about git is that we can create feature branches, do something we think would be handy and then issue a pull request when we have it working.. you can then choose to merge it into the code base or not.  Most likely a lot of folks would end up committing code to the project this way  and so long as you make it clear that all code committed in this manner must be clean, dry and easy to understand it ends up being a win win for everyone..

8
Support / Unable to log into second store with identical user settings
« on: March 07, 2012, 03:13:51 PM »
Code: [Select]
mysql> select * from store.users;
+---------+---------------+-----------+----------------------------------+-----------+----------+-----------------------+--------+----------------+---------------------+---------------------+
| user_id | user_group_id | username  | password                         | firstname | lastname | email                 | status | ip             | date_added          | last_login          |
+---------+---------------+-----------+----------------------------------+-----------+----------+-----------------------+--------+----------------+---------------------+---------------------+
|       1 |             1 | palamedes | 2f28fea59aa3979397385178ea4a0051 | aaaaa     | bbbbb    | aaaaa.bbbbb@yahoo.com |      1 | 172.179.21.203 | 2012-03-06 13:22:19 | 2012-03-07 12:12:34 |
+---------+---------------+-----------+----------------------------------+-----------+----------+-----------------------+--------+----------------+---------------------+---------------------+
1 row in set (0.00 sec)

mysql> select * from secondstore.users;
+---------+---------------+-----------+----------------------------------+-----------+----------+-----------------------+--------+----------------+---------------------+---------------------+
| user_id | user_group_id | username  | password                         | firstname | lastname | email                 | status | ip             | date_added          | last_login          |
+---------+---------------+-----------+----------------------------------+-----------+----------+-----------------------+--------+----------------+---------------------+---------------------+
|       1 |             1 | palamedes | 2f28fea59aa3979397385178ea4a0051 | aaaaa     | bbbbb    | aaaaa.bbbbb@yahoo.com |      1 | 172.179.21.203 | 2012-03-06 13:22:19 | 2012-03-07 08:44:27 |
+---------+---------------+-----------+----------------------------------+-----------+----------+-----------------------+--------+----------------+---------------------+---------------------+
1 row in set (0.00 sec)


I have two installs store and secondstore.. both have identical admin accounts with the same password -- I made sure of this by updating the second stores table to be that of the first store..  Yet I can't login to the second store as it says no match for user name/password..  but it works fine on the first store.

Note; it was working fine before I did a backup of one store, and restored it to the other store to test those features.

Cache issue?

9
General Discussion / All product images in one directory is a bad idea
« on: March 07, 2012, 02:56:04 PM »
A system like this one will most likely inspire folks to add a lot of products.. With lots of products you will most likely get a lot of media in the form of images for each product.

Your system as it stands now creates 4 versions of each image in the form of thumbnails of various sizes.  So right there we have 4x the number of images actually uploaded.

And all of them live in image/thumbnails .. this is a bad idea .. It wont take long before this directory will bloat to ridiculous size..

Modern ext3 file system will allow you to have virtually an infinite number of entries so you are unlikely to run into the natural limit of the filesystem, but the more files you have in there the slower your file access time will be thus possibly adding a noticeable drag on page loads.   And you can't assume ext3 will be the file system.  NFS has a limit of 32k..

I would suggest each category or even each product getting it's own directory.. Currently images appear to be {productid/type}-{imageid}-{size}.extension

Probably not a bad idea to have the product id be a directory.

10
Existing features / Backup/Restore seems largely non-functional
« on: March 07, 2012, 02:38:14 PM »
Create two installs of AbanteCart Cart.  One will be your development or staging install, and one will be the production install.

Add a bunch of stuff to the develop install; categories, merchants, products, images etc..

Back up that "developer" install and restore it to the other "production" fresh install.  This should (and needs to) 100% work allowing you to migrate test on one machine and update to another production install.  It doesn't.

No media is backed up at all and should be -- copy/pasting the images directory structure over doesn't work either or rather only partially works.
Categories and Merchant (brand) listings on the page don't update likely due to some template caching issue.
Etc..

This area needs a lot of love.

11
New Features Discussion / Random sort order for products
« on: March 07, 2012, 01:25:34 PM »
MySQL allows for a random order of items..  It would be nice if we could have a sort by that uses "ORDER BY RAND()" for product category pages so that it shows a random listing.


12
It would be extremely nice (to the point that if you don't write it I'm going to add it) to have a flag in the product creation/editor page to "delist" or flip the status of a product to OFF when the number in stock reaches zero.

If you guys ever push AbanteCart out to git we can start adding these things in feature branches that you can pull into the main code base =)

13
New Features Discussion / Allow us to define the SEO space separator
« on: March 07, 2012, 12:09:14 PM »
When an admin creates a category or product and they don't enter an SEO string you guys autogenerate one from the title and replace spaces with underscores.   Allow me to define that.  I should be allowed to use dashes, underscores or no spaces at all.  All are valid in the SEO world and each person has their preferences.. (I prefer dashes)

Note:  Right now if I enter  Test " Foo & Bar as my SEO string for something it converts to this; store.com/Test%20Category%20%22%20Foo%20&%20Bar

That's broken.  It should lower case it, convert the spaces to the users choice of dash, underscore or nothing, and strip all characters ^[a-zA-Z0-9]

14
Right now if an item comes up as "out of stock" you can still add it to your cart.. It does so with the *** telling you that the item is on back order or that it may not be in stock.

This is fine for products in which there are more than one, but for unique items (like hand crafted unique one of a kind items) it is less appropriate.  Instead it would be nice if we could flag a product/item as unique and the "Add to cart" button would be either removed entirely or replaced with an email button or some way to let a person ask about maybe getting another one similar to this item..

15
New Features Discussion / Product date expires
« on: March 07, 2012, 12:16:13 AM »
Currently products have a "date available" which I assume is when a product starts getting listed, but no end date.  It would be nice to be able to set an automatic termination date on products. 

Pages: [1] 2

Powered by SMFPacks Social Login Mod